How no to round off values ?

cosec · Post by **cosec** » Fri Jul 13, 2007 2:25 am

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

ArndW · Post by **ArndW** » Fri Jul 13, 2007 3:03 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Jul 13, 2007 2:48 pm

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.