Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Help! Calculated field Total of summary field giving incorrect result.


Recommended Posts

Please help with this SOON!!! - Calculated field Total of summary field giving incorrect result.


We have a report that has the following problem, hope someone can assist us with this real soon. Thanks.


Student Principal is a calculated field (unstored). The calculation is based on the Amount Collected (a number field) multiply by the Student Discount (a number field) divided by 100.


Example: cStudentPrincipal = AmountCollected * StudentDiscount / 100

218.44 * 80 / 100 = 174.75

In the body of the report the cStudentPrincipal computes fine.


We have a summary field (sRptStudentPrincipal) that is Total of cStudentPrincipal.

This field is in a sub-summary part and prints when the department breaks.

This result is sometimes one cent too much or one cent too little (it seems to be randomly truncating or rounding).


The same summary field is in the trailing Grand Summary to get the total of all departments at the end of the report.


Please help. We have tried the calculated field (cStudentPrincipal) as stored calculation that did not work.


Is there something unique or extra that has to be done when using a calculated field as total in a summary field? We have several report/layout with this problem.


Also, calculated field seems to randomly round or truncate incorrectly. What is the best way to use to ensure correct results all the time?


Thanks Very Much.

Link to comment
Share on other sites

Your example of 218.44 * 80 / 100 = 174.75

brings back a total of 174.752


Which by the way could be done as follows

218.44 * .8 = 174.752


You are displaying decimal with 2 places

therefore if .005 or less will round down to .00

if .006 or higher will round up to .01


What can you do about it.? Use number like 218.50


i.e. your example

218.50 * 80/100 = 174.80


218.50 * .8 = 174.80


or you can display with more decimals

but who pays in fractions of pennies?

Link to comment
Share on other sites

Have you tried to add the round function to the calculation field.


Round(AmountCollected * StudentDiscount/100,2)


This will always make sure that you round to two decimal places.


Your example of 218.44 * 80 / 100 = 174.75 is correct, because you are only displaying 2 decimal places, although it actually works out to 174.52.


So, when you do a subsummary, this .000 is being taken into account and will round up, giving you a false reading. But, if in your calc you use the round function, the number will only ever be 174.75 and therefore in your summary will be correct, to the nearest dime (or quarter, or cent)



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use