Skip to main content
Topics#Data ManagementQuestion de Shelby Verzinskie
Shelby Verzinskie (Trimont Real Estate Advisors) a posé une question dans #Data Management
25 avr. 2018, 10:53

Case Formula - Admin Not a Developer

I am an administrator (not a developer AT ALL) and I'm trying to write what is most likely a fairly straightforward CASE formula, but I'm not getting it quite right.

 

I'm creating a field which I want to perform a certain calculation depending on the Stage selected.

 

CASE(StageName, "Prospect Identified",  Amount , "Initial Discussions", Amount, "Proposal", Amount, "Negotiation", Amount, "Awarded",   (Spec_Pledges_Portfolio_Investment_Amount__c)  +  (Named_Pledges_Portfolio_Investment_Amt__c)  +  (Closed_Pledges_Portfolio_Investment_Amt__c),  "Closed",  (Spec_Pledges_Portfolio_Investment_Amount__c)  +  (Named_Pledges_Portfolio_Investment_Amt__c)  +  (Closed_Pledges_Portfolio_Investment_Amt__c) )

 

 

 

Error: Incorrect number of parameters for function 'CASE()'. Expected 12, received 13

 

Any help is appreciated.

 

Thanks!

Shelby

6 réponses
  1. Chris Duncombe (Imprivata)
    25 avr. 2018, 10:59
    Try this

     

     

    CASE(
        TEXT(StageName), 
        "Prospect Identified",  Amount , 
        "Initial Discussions", Amount, 
        "Proposal", Amount, 
        "Negotiation", Amount, 
        "Awarded", (Spec_Pledges_Portfolio_Investment_Amount__c +  Named_Pledges_Portfolio_Investment_Amt__c +  Closed_Pledges_Portfolio_Investment_Amt__c),  
        "Closed", (Spec_Pledges_Portfolio_Investment_Amount__c +  Named_Pledges_Portfolio_Investment_Amt__c +  Closed_Pledges_Portfolio_Investment_Amt__c),
        Amount
    )

     

     
Rédiger une réponse...
0/9000