cancel
Showing results for 
Search instead for 
Did you mean: 

Always round up to nearest whole in APO DP

Former Member
0 Kudos

Hi

there is a requirement to always round up data to nearest whole number. number should be always rounded above and not rounded down.

Example a value of 0.07 should be rounded to 1

a value of 1.25 should be rounded to 2

a value of 1.75 should be rounded to 2

a value of 1.07 should be rounded to 2

and so on

Is there a way i can achieve in APO DP by some settings/paramater/config/macro/exit etc etc - i am on SCM 7.0

Thanks,

TJ

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Tejinder

Try using the CEIL() function in a macro.

Rishi Menon