function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Steve CairneySteve Cairney 

Grand total bug workaround?

Hi all, you may or may not know that there is a bug when you use percentages in a custom formula within a report. For some reason the grand total never adds up.

The bug has been around for some years and still isn't fixed. Has anyone ever come up with a workaround they could share?

My example uses percentages to work out commission. The report is a summary report. My custom formula is as follows:
IF(Opportunity.Margin__c:SUM <= 10000, Opportunity.Margin__c:SUM * 0.06,

IF(AND(Opportunity.Margin__c:SUM >= 10001,Opportunity.Margin__c:SUM <= 20000),
Opportunity.Margin__c:SUM * 0.11,

IF(Opportunity.Margin__c:SUM >= 20001, Opportunity.Margin__c:SUM * 0.15,0

That works fine, the problem is adding the totals up manaully comes to 27,100.56 but the Grand Total on the report (which would be essential when it comes to the Dashboard I'll create) adds the total up to 33,540.53.

Not ideal!

The bug is reported here

Has anyone any suggestions about battling this?