Round Formula Returning Null Values

Hi,

I have got a formula [TOTALDEBITS]/180*30. The field TOTALDEBITS has got numerical values of a Fixed Decimal type. I would like to round the outcome of my [TOTALDEBITS]/180*30 formula to the nearest whole number using Round(([TOTALDEBITS] / 180 * 30), 0). However the outcome of this round formula is generating null values throughout the entire output field. Can someone let me know where i could be going wrong?

Preparation

Accepted answers

alexnajm

Round(([TOTALDEBITS] / 180 * 30), 1) should work!

All comments

alexnajm

Round(([TOTALDEBITS] / 180 * 30), 1) should work!

AlvinA

Thanks this worked.

jrlindem

@AlvinA Just for kicks, the ROUND() function isn't the number of decimals, so your example of "0" doesn't work. It's an indication of the precision where "1" is whole number, "0.01" would be to the hundredths, etc. This trips me up every now and again too 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703