I'm trying to round the values in a pivot table to 2 decimal places.  The pivot report is based on a view which is based on a form field called Square Foot Cost.  In the scripting for this field I've included Value = Square_Foot_Cost.round(2) which seems to work well on this calculated field when displayed as a view (rounds correctly to two decimal places).

However, when I created the pivot table report based on that view, it would not round to 2 decimal places.  I think I ended up with 5-7 decimal places.

Any idea why it does this and how I can fix it?