function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Steve CairneySteve Cairney 

Use record ID, Profile ID in report formula?

Hi, I've created a formula in a summery report to calculate user commision. it's works but I need to add certain caveates into the formula.

Here's what I've got 
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
)))

This works out the commsions based on the critera fine. However I need to add in record ID (if record ID = x, don't calculate) and also Profile. IF profile = X, use this calculation.

Does anyone know if this is possible in a summary report?
Parker EdelmannParker Edelmann
Hi Steve Cairney,
To my knowledge you cannot reference non-summary fields, but it seems that you could easily create this as a field on the object itself. Would it be possible to do it there?
Steve CairneySteve Cairney
Not really becuase the SUM is based on the accrument SUM of the Opp records per user based on the date of close.