ROUND Function

vinsnash

I have to do a calculation rounding the result. I've read the description of the 'ROUND' function but it doesn't seem to be what I need or I just can't extrapolate the syntax to my situation.

I have a rule NSCPers.AmountPaid = NSCPers.Months * FeeTable.Amount

FeeTable.Amount is two digits with two decimals '99.99'. I need NSCPers.AmountPaid to be rounded up to a whole number.

Can someone show me the syntax to accomplish that?

Thanks

Vins Nash

tford

There is no function to specifically round UP, so you will have to do some calc on your own.

Off the top of my head, I THINK you can add 0.99 to your number, then round to the whole number.

aware_support

There are actually functions that can round up and down specifically. They are called CEILING (or CEIL, can't remember) and FLOOR respectively.

tford

Oops -- sorry about that. Learning something new about AwareIM every day.

vinsnash

That works! Thank you. Ceiling and Floor? Only in Australia.

Vins Nash

aware_support

Ceiling and Floor? Only in Australia.
These are standard math names for these functions, so please be gentle to Aussies... 😃