Hi,
I want to implement a ROUND function to get a value.
Like,
TOTAL AMOUNT = ROUND(Conversion Rate * Amount,4)
Example:
Conversion Rate = 1.234564
Amount = 56
TOTAL AMOUNT = 69.135584 but after the ROUND operator the value
sholud be 69.1356.
How can this be implemented in the Datastage?
Using of ROUND function
Moderators: chulett, rschirm, roy
Using of ROUND function
Harsha gks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Modify stage with output link having a scale of 4 for this particular Decimal data type. Use decimal_from_decimal() function with [round_inf] as the rtype argument.
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.
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: Using of ROUND function
Try this:Harshagks wrote: Conversion Rate = 1.234564
Amount = 56
TOTAL AMOUNT = 69.135584 but after the ROUND operator the value
sholud be 69.1356.
Code: Select all
FMT(Arg1*Arg2, "R4")
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm