You need to sign in to do that
Don't have an account?
Selvakumar Anbazhagan 12
Error in Opportunity Formula Field
Hi,
I having issue to create a new formula field in opportunity. when i was tried to create it shows me the below error
Error: Incorrect number of parameters for function 'CASE()'. Expected 6, received 7..
My formula is :
OR
(CASE(Owner.Profile.Name,
"Account Executive", "Outbound",
"Commercial Bulk Executive", "Bulk",
"Inbound Sales", "Inbound",
"Outside Sales Agent", "Agent",
"Sales Director/Manager", "Mgmt",
"System Administrator", "Admin",
"Other"
),
CASE(Owner.Profile.Name,
"Maria Martinez", "Agent",
"Michael Smith","Carrier",
"Robert Johnson","Carrier"
),
if(RecordType.Name="Carrier Devices","Carrier","Other")
)
Any help on this.
Thanks.
I having issue to create a new formula field in opportunity. when i was tried to create it shows me the below error
Error: Incorrect number of parameters for function 'CASE()'. Expected 6, received 7..
My formula is :
OR
(CASE(Owner.Profile.Name,
"Account Executive", "Outbound",
"Commercial Bulk Executive", "Bulk",
"Inbound Sales", "Inbound",
"Outside Sales Agent", "Agent",
"Sales Director/Manager", "Mgmt",
"System Administrator", "Admin",
"Other"
),
CASE(Owner.Profile.Name,
"Maria Martinez", "Agent",
"Michael Smith","Carrier",
"Robert Johnson","Carrier"
),
if(RecordType.Name="Carrier Devices","Carrier","Other")
)
Any help on this.
Thanks.
Can you help us understand what are you trying so that we can frame the right formula for you ?
"Maria Martinez", "Agent",
"Michael Smith","Carrier",
"Robert Johnson","Carrier"
),
It might solve the error if you add a "," there with blank value. If this solves your problem like this answer.
Even am getting error.
Actually i want a formula field in opportunity to categorize the channels (Inbound,outbound,Agent or Carrier) from various objects (Profile,Opportunity,Recordtype).
So i created the below logic.
OR
(CASE(Owner.Profile.Name,
"Account Executive", "Outbound",
"Commercial Bulk Executive", "Bulk",
"Inbound Sales", "Inbound",
"Outside Sales Agent", "Agent",
"Sales Director/Manager", "Mgmt",
"System Administrator", "Admin",
"Other"
), /* Categorize channel using Profile */
CASE(Opportunity.Owner.Name,
"Maria Martinez", "Agent",
"Michael Smith","Carrier",
"Robert Johnson","Carrier",
"Other"
), /* Categorize channel using owner name */
if(RecordType.Name="Carrier Devices","Carrier","Other")
) /* Categorize channel using recordtype */
Is this makes sense ?
Thanks.