I have a Calculated Column in a Gridview: {Sold LY} /12

The results have too many decimal places. How can I limit the decimal places to 2?

Hi Susan:
Right-click on the column, choose "Add formatting" then "Format" tab then enter "2" as the "Precision".

Doesn't seem to be working. What do you have as the format type?

Hi Susan,

Try 'comma' as the format. Also, there are increase/decrease decimal buttons on the toolbar - select the column and click the decrease decimal button.

You could also try rounding the calculated amount -> use ROUND({Sold LY} /12,2) to round the value to 2 decimal places.

Susan:
I used "(Comma)". I have a percentage column and I can change the number of decimals at will.

Comma with Precision are working... until I summarize.

Hi Susan,

I think you might need to click on the Total cell and apply the comma format to that cell specifically. It's a bug (or at least not the behaviour you might expect when you highlight the column).

When I do that and summarize the whole column goes blank.