Round to nearest 50

1

Hi there,

I have a need to round a currency field to nearest 50 (whole number). If this was C#, I would use the following.

((int)Math.Round(number / 50.0)) * 50

where number is the currency field value.

Thanks,
Aatash

2

Welcome to the Community, Aatash!

EasyMorph has two rounding functions:

round() - the most close to Math.Round in C#

roundxl() - uses the same rounding logic as ROUND() in Excel.

I guess, in your case the expression would be:

round( [Number] / 50, 0) * 50
3

Thank you. round( [Number] / 50, 0) * 50 worked for my purpose.