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
How no to round off values ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.