Round Formula Returning Null Values

[AlvinA]

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?

[alexnajm · Accepted solution]

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 🙂