Rounding off function in PX

[Ramani]

Hi,

Is there a function to round off number value.

something like

Round(10.1245, 2) = 10.13

Thanks

[mahadev.v]

Use DecimaltoDecimal conversion. rtype I think is 'round_' something. Search the parallel job developers guide on 'rtype'.

[Vikas Jain]

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~~