Skip to main content
Topics#Data ManagementMelody Goede's Question
Melody Goede (Sunquest Information Systems) asked in #Data Management
Oct 13, 2017, 9:37 PM

HELP! with a formula... If ISPICKVAL = x, then SUM these fields

I'm trying to build a formula field that provides an equation IF one field has one of two values in a picklist...

 

If my primary solutoin field is either geneinsight or molecular, then I want the field to ppoulate with the resutling $ from the equation  total annula maintenance  * 2 + amount.

 

I can't quite sem to ge there....

 

IF(

 

AND(

 

ISPICKVAL(Primary_Solution__c, "GeneInsight") OR

 

ISPICKVAL(Primary_Solution__c, "Molecular"),

 

(Total_Annual_Maintenance_Amount__c*2+Amount)))
2 answers
  1. Sunil Sarilla (M&G Investments)
    Oct 13, 2017, 10:43 PM
    Hi Melody,

     

    Please try the below and I have assumed if the Primary Solution is not one of those 2 values you want your formula to return blank

    IF(
    OR(
    ISPICKVAL(Primary_Solution__c, "GeneInsight"),
    ISPICKVAL(Primary_Solution__c, "Molecular")
    ),
    (Total_Annual_Maintenance_Amount__c*2)+Amount,
    NULL
    )

     

    you could also use CASE Function  as below to write the same formula

    IF(
    CASE(Primary_Solution__c, 
    "GeneInsight",1
    "Molecular",1,
    0)=1,
    Total_Annual_Maintenance_Amount__c*2)+Amount,
    NULL
    )

     

     
Write an answer...
0/9000