You need to sign in to do that
Don't have an account?
Steve 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:
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 https://success.salesforce.com/ideaview?id=08730000000Bq9DAAS
Has anyone any suggestions about battling this?
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 https://success.salesforce.com/ideaview?id=08730000000Bq9DAAS
Has anyone any suggestions about battling this?