+ Start a Discussion
udayar_jayamudayar_jayam 

Picklist Value change

     Hi All,

                     I have Picklist value None,External,Internal,when i select none the Resource(percent) Fields remains zero or i select external and internal value ,the input value same what i entered in the Resource field.Based on the percentage value i need to calculate the total amount.How to solve this issues.

Daniel B ProbertDaniel B Probert

something like this should do the trick if i understanding you correctly. i'm presuming that the resource field is a formula field already?

 

if(ispickval(customfield__c,"None"),0,

if(ispickval(customfield__c,"External"),25,

if(ispickval(customfield__c,"Internal"),50, null)))

 

you could even just reduce this further by simply setting the picklist to default of none, then use this formula

 

if(ispickval(customfield__c,"External"),25,

if(ispickval(customfield__c,"Internal"),50, 0))

 

if the resource field is not a picklist then you will need to create a workflow to acheive what your looking to do.

 

thanks

dan

 

if this helped kudos it :)