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
EAF1EAF1 

CASE Statement - Nested

Anyone HELP Please!

 

I am trying to write this as an IF statement - but I believe that it needs to be a CASE  statement.

 


IF  (ISPICKVAL(Type, "PEO"),

Then Calculate

[
IF(ISPICKVAL(Commission_Rate_PEO__c,"1 %"),Employee_Remuneration_Total__c  * 0.01,
IF(ISPICKVAL(Commission_Rate_PEO__c,"1.5 %"),Employee_Remuneration_Total__c  * 0.015,
IF(ISPICKVAL(Commission_Rate_PEO__c,"2 %"),Employee_Remuneration_Total__c  * 0.02,
IF(ISPICKVAL(Commission_Rate_PEO__c,"2.5%"),Employee_Remuneration_Total__c  * 0.025,
IF(ISPICKVAL(Commission_Rate_PEO__c,"3 %"),Employee_Remuneration_Total__c  * 0.03,
IF(ISPICKVAL(Commission_Rate_PEO__c,"3.5%"),Employee_Remuneration_Total__c  * 0.035,
IF(ISPICKVAL(Commission_Rate_PEO__c,"4%"),Employee_Remuneration_Total__c  * 0.04,
IF(ISPICKVAL(Commission_Rate_PEO__c,"4.5%"),Employee_Remuneration_Total__c  * 0.045,
IF(ISPICKVAL(Commission_Rate_PEO__c,"5%"),Employee_Remuneration_Total__c  * 0.05,
Employee_Remuneration_Total__c  * 0.02))))))))))
]

Else

Return

0

 

Any suggestions

Ispita_NavatarIspita_Navatar

Do try the following:-

 

 

CASE(Commission_Rate_PEO__c,

1,Employee_Remuneration_Total__c  * 0.01,

1.5,Employee_Remuneration_Total__c  * 0.015,

2,Employee_Remuneration_Total__c  * 0.02,

2.5,Employee_Remuneration_Total__c  * 0.025,

3,Employee_Remuneration_Total__c  * 0.03,

3.5,Employee_Remuneration_Total__c  * 0.035,

4,Employee_Remuneration_Total__c  * 0.04,

4.5,Employee_Remuneration_Total__c  * 0.045,

5,Employee_Remuneration_Total__c  * 0.05,

0)