Page 1 of 1
How no to round off values ?
Posted: Fri Jul 13, 2007 2:25 am
by cosec
Hi
I performing some calculations and I dont want the values to be rounded off
for example
a value such as 1997.899 after the calculation should be 1.997 and not 1.999
Posted: Fri Jul 13, 2007 3:03 am
by ArndW
How and in which stage are you doing the rounding or conversion by moving the decimal over 3 places? The answer to this will go a long way to answering your question
Posted: Fri Jul 13, 2007 2:48 pm
by ray.wurlod
Maybe it's a typo, but I can't see any way 1.999 would be a result if 1.997 is. Anyway, there are lots of ways to avoid rounding; for example by specifying "T" in the Fmt() function. It really depends, as Arnd says, on where you are (not) doing the rounding. To do rounding is DataStage's default behaviour, so you will need to specify something to indicate that you want to override this default behaviour.