You need to sign in to do that
Don't have an account?
Steve Cairney NOW
Is it possible to calculate a total based on PICKLIST values?
Hi, I'm spitballing here, but if I had a couple of PICKLIST's that contained the terms
Excellent
Average
Poor
and these where assigned a value is true in an IF statement (3,2,1) would it be possible to get a total to give a final score?
Example:
IF(ISPICKVAL( picklist__c, "Excellent"), 3,0,
IF(ISPICKVAL( picklist__c, "Average"), 2,0,
IF(ISPICKVAL( picklist__c, "Poor"), 1,0,
0
)))
Can I add another picklist__c in the same formula and add up the results?
Excellent
Average
Poor
and these where assigned a value is true in an IF statement (3,2,1) would it be possible to get a total to give a final score?
Example:
IF(ISPICKVAL( picklist__c, "Excellent"), 3,0,
IF(ISPICKVAL( picklist__c, "Average"), 2,0,
IF(ISPICKVAL( picklist__c, "Poor"), 1,0,
0
)))
Can I add another picklist__c in the same formula and add up the results?
I've assumed that there are two picklist's on your object pick1__c and pick2__c both with same values, "Excellent','Average' and 'Poor'.
i created this formula field of return type number with the follwing formula:
IF( ISPICKVAL( pick1__c , 'Excellent') , 3, IF( ISPICKVAL( pick1__c , 'Average') , 2, IF( ISPICKVAL( pick1__c , 'Poor') , 1, 0) ) ) + IF( ISPICKVAL( pick2__c , 'Excellent') , 3, IF( ISPICKVAL( pick2__c , 'Average') , 2, IF( ISPICKVAL( pick2__c , 'Poor') , 1, 0) ) )
is this what you were looking for ?
All Answers
Do you have multiple picklist on the same object or do you want to calculate this sum on the master object ?
I've assumed that there are two picklist's on your object pick1__c and pick2__c both with same values, "Excellent','Average' and 'Poor'.
i created this formula field of return type number with the follwing formula:
IF( ISPICKVAL( pick1__c , 'Excellent') , 3, IF( ISPICKVAL( pick1__c , 'Average') , 2, IF( ISPICKVAL( pick1__c , 'Poor') , 1, 0) ) ) + IF( ISPICKVAL( pick2__c , 'Excellent') , 3, IF( ISPICKVAL( pick2__c , 'Average') , 2, IF( ISPICKVAL( pick2__c , 'Poor') , 1, 0) ) )
is this what you were looking for ?