Leaving only 2 decimal places

[john cesta]

I have this in my calculation field

[Annual]*27/100

My result is like

34.337744820

How to leave only 2 decimal places

I’ve also tried just .27 for percent and set 2 decimal places in the properties.

[Sam Moffatt]

Make sure the output of the calculation is set to number not text. The number formatting options only apply to number outputs. I just did a quick test to do 22/7 in a calculation field and the decimal places setting seemed to work.

[Brendan]

You also have to make sure you set the Number Format to Decimal, otherwise the Decimal Places property will be ignored.

[john cesta]

Number format was set to no style, thanks both.

[Author]

Posts