You need to sign in to do that
Don't have an account?
KNK
Formula field..
Hi Team,
I am trying to create a formula filed based on another picklist field value, but it is not populating the value in formula filed.
Please find below for the formula and help me here..
IF( ISPICKVAL(Product_Mix_GP__c,'<50.00') ,2,
(IF( ISPICKVAL(Product_Mix_GP__c,'50.00-100.00') ,6,
(IF( ISPICKVAL(Product_Mix_GP__c,'100.00-150.00') ,9,
(IF( ISPICKVAL(SYN_Turnover_seeds_CP__c,'150.00-200.00') ,12,
(IF( ISPICKVAL(SYN_Turnover_seeds_CP__c,'>200.00') ,15,0)))))))))
Naresh,
If all the values are coming from the same picklist, you're better off using a CASE() function instead of the nested IF() calls, like so:
It is easier to read and maintain, and it's more efficient.
All Answers
(IF( ISPICKVAL(Product_Mix_GP__c,'50.00-100.00') ,6,
(IF( ISPICKVAL(Product_Mix_GP__c,'100.00-150.00') ,9,
(IF( ISPICKVAL(Product_Mix_GP__c,'150.00-200.00') ,12,
(IF( ISPICKVAL(Product_Mix_GP__c,'>200.00') ,15,0)))))))))
Naresh,
If all the values are coming from the same picklist, you're better off using a CASE() function instead of the nested IF() calls, like so:
It is easier to read and maintain, and it's more efficient.