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
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
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- 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.