I'm trying to figure out a formula and need some help. The following is a formula I’m using that calculates a number for me. I’ll define each piece first
ACCI__c is a product
326 is a dollar amount
Number of Eligible EEs__c is an employee count
*0.20 gives me 20% of 326 x Employees
The rest is if there is no number.
 
IF ( ACCI__c , 326* (Number_of_Eligible_EEs__c*0.20) , 0* Number_of_Eligible_EEs__c )
 
So, here’s what I’m trying to do. First I have another picklist field I added called Target__c and the values are Target and Non-Target.
 
Example: If Eligible_EEs__c is between 100 and 200 and the picklist value from Target__c chosen is Target then the multiplier is 0.20, but if Eligible_EEs__c is 100 to 200 and the picklist value from Target__c is Non-Target the multiplier is 0.18
 
If Eligible_EEs__c is 201 to 400 and the picklist value from Target__c is Target then 0.16
If Eligible_EEs__c is 201 to 400 and picklist value from Target__c is Non-Target then 0.14
 
Would appreciate the correct formula to accomplish this. The head count variances and picklist values is where I’m stuck.
 

Hi All,

when I save the below formula, it shows this error:

 

Error: Compiled formula is too big to execute (19,959 characters). Maximum size is 5,000 character

 

if the sum of Value_1__c to Value_13__c <= 10, then  display level 1

if the sum of Value_1__c to Value_13__c >10 and Value_1__c to Value_13__c <= 18, then  display level 2

if the sum of Value_1__c to Value_13__c >18 then level 3

 

 

formula value:

if((Value_1__c + Value_2__c +Value_3__c + Value_4__c + Value_5__c + Value_6__c + Value_7__c + Value_8__c + Value_9__c+ Value_10__c + Value_11__c + Value_12__c + Value_13__c) <= 10

&&
(Value_1__c + Value_2__c +Value_3__c + Value_4__c + Value_5__c + Value_6__c + Value_7__c + Value_8__c + Value_9__c+ Value_10__c + Value_11__c + Value_12__c + Value_13__c ) <> 0 , "Level 1",
if( AND((Value_1__c + Value_2__c +Value_3__c + Value_4__c + Value_5__c + Value_6__c + Value_7__c + Value_8__c + Value_9__c + Value_10__c + Value_11__c + Value_12__c + Value_13__c) > 10
&&
(Value_1__c + Value_2__c +Value_3__c + Value_4__c + Value_5__c + Value_6__c + Value_7__c + Value_8__c + Value_9__c+ Value_10__c + Value_11__c + Value_12__c + Value_13__c) <= 18), "Level 2",
if((Value_1__c + Value_2__c +Value_3__c + Value_4__c + Value_5__c + Value_6__c + Value_7__c + Value_8__c + Value_9__c+ Value_10__c + Value_11__c + Value_12__c + Value_13__c) > 18,"Level 3",
"Level Not Calculated Yet" )))

 

 

All field Value_1__c to Value_13__c also formula field which get s the value from the picklist selected.

 

we tried this also:

 

total_risk_cal__c = Value_1__c + Value_2__c +Value_3__c + Value_4__c + Value_5__c + Value_6__c + Value_7__c + Value_8__c + Value_9__c+ Value_10__c + Value_11__c + Value_12__c + Value_13__c

if((total_risk_cal__c) <= 10
&&
(total_risk_cal__c ) <> 0 , "Level 1",
if( AND((total_risk_cal__c) > 10
&&
(total_risk_cal__c) <= 18), "Level 2",
if((total_risk_cal__c) > 18,"Level 3",
"Level Not Calculated Yet" )))

 

but getting same error.

 

 

Kindly tell how resolve this