Hi,
Is there a function to round off number value.
something like
Round(10.1245, 2) = 10.13
Thanks
Rounding off function in PX
Moderators: chulett, rschirm, roy
Rounding off function in PX
Thanks
-
- Participant
- Posts: 15
- Joined: Tue Dec 13, 2005 12:38 am
use round_inf
Hi,
It might have been a little late for you, but I saw this thread today while scanning through something else.
One of the way ( a convenient one) to achieve round off in PX is using round_inf as an argument with type conversion function like DecimalToDecimal
An example can be like this:
DecimalToDecimal((LNK_JOIN_CUSTOMER.AVERAGEAGE_OF_ACCOUNTS/ 365),'round_inf')
hope this helps to other Datastagians
~~Vikas~~
It might have been a little late for you, but I saw this thread today while scanning through something else.
One of the way ( a convenient one) to achieve round off in PX is using round_inf as an argument with type conversion function like DecimalToDecimal
An example can be like this:
DecimalToDecimal((LNK_JOIN_CUSTOMER.AVERAGEAGE_OF_ACCOUNTS/ 365),'round_inf')
hope this helps to other Datastagians
~~Vikas~~