AnsweredAssumed Answered

Summary Field -- Totals not adding displayed decimals properly

Question asked by firth5 on Apr 1, 2010
Latest reply on Apr 2, 2010 by philmodjunk

Title

Summary Field -- Totals not adding displayed decimals properly

Post

I've got several Summary Fields where the (displayed) total does not add up the (displayed) subtotals correctly, due to undisplayed decimal places.

 

For example, I have Subtotals A-F, which each display 2 decimal places (but in actually, due to what they are adding up, could be up to 4 decimal places behind the scenes.)

Then I have the Total, which also displays only 2 decimal places.  This is occasionally a penny off, due to the unseen decimal places of the subtotals.

 

What is the best way to solve this?  

 

(My solution would be to create a secondary calc field for each subtotal.  Each calc field would pull the number from the summary field, then drop off the everything to the right of the first 2 decimal places.  Then my TOTAL field would add up these calc fields, instead of the actual summary fields.

I'm just wondering if there's some built-in checkbox or something within FM that I can use.)

Outcomes