I am at the character limit for a commission formula that is in a report someone else set up that I am trying to edit. I have got the below repeated numerous times in the formula with the differentiator being the >=. Does anyone have any suggestions on cutting down the text so I can get more levels of the commission structure into the formula?
IF(
Monthly_Term__c.Monthly_Grouping_BE__c:MAX < PARENTGROUPVAL(Monthly_Term__c.Monthly_Grouping_BE__c:MAX, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY),NULL,
IF(((
((PREVGROUPVAL(Monthly_Term__c.Roster_Value__c:SUM, Monthly_Term__c.CreatedDate,1) - (Monthly_Term__c.Term_Value_w_buyouts__c:SUM - Monthly_Term__c.Buyout_Value__c:SUM))
/PREVGROUPVAL(Monthly_Term__c.Roster_Value__c:SUM, Monthly_Term__c.CreatedDate,1))
+
((PREVGROUPVAL(Monthly_Term__c.Roster_Value__c:SUM, Monthly_Term__c.CreatedDate,2) - (PREVGROUPVAL(Monthly_Term__c.Term_Value_w_buyouts__c:SUM, Monthly_Term__c.CreatedDate,1) - PREVGROUPVAL(Monthly_Term__c.Buyout_Value__c:SUM, Monthly_Term__c.CreatedDate,1))
)/PREVGROUPVAL(Monthly_Term__c.Roster_Value__c:SUM, Monthly_Term__c.CreatedDate,2))
+
((PREVGROUPVAL(Monthly_Term__c.Roster_Value__c:SUM, Monthly_Term__c.CreatedDate,3) - (PREVGROUPVAL(Monthly_Term__c.Term_Value_w_buyouts__c:SUM, Monthly_Term__c.CreatedDate,2) - PREVGROUPVAL(Monthly_Term__c.Buyout_Value__c:SUM, Monthly_Term__c.CreatedDate,2))
)/PREVGROUPVAL(Monthly_Term__c.Roster_Value__c:SUM, Monthly_Term__c.CreatedDate,3))
)/3)
>= 0.9933,
1000,
IF(
Monthly_Term__c.Monthly_Grouping_BE__c:MAX < PARENTGROUPVAL(Monthly_Term__c.Monthly_Grouping_BE__c:MAX, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY),NULL,
and so on
