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 risposte
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
)
