Calculated field with if..then, not returning as expected | Community
Skip to main content
New Participant
April 18, 2025
Solved

Calculated field with if..then, not returning as expected

  • April 18, 2025
  • 1 reply
  • 421 views

Hi, I thought I had this calculated expression written correctly, but everything returns "Other".  Have I missed some syntax somewhere or should I be using a different expression.

 

IFIN({DE:*PRM Project Type}, "Adhoc", "Funded- Signature", "Funded-P&P","Funded-A&E","Conferences/Events/Webinars", "Funded (Signature)", "Japan","QUANT Client/Member","Research Circle", CONCAT("Primary Research"),IFIN({DE:*PRM Project Type},"Gartner Benchmark","Gartner Score","QUANT Benchmarks & Diagnostics", CONCAT("Benchmark & Diagnostics"),CONCAT("Other")))

 

The *PRM project type field is a single select dropdown and we do have 'show values' on.  I wasn't sure if that was causing an issue.

 

You can see that it always calculates to 'Other'

 

Thank you!

 

Best answer by Sven-iX

I think you need to use the VALUE - not the label in the expression

Meaning "Adhoc" is the label, and "A" is the value

1 reply

Sven-iX
Sven-iXAccepted solution
New Participant
April 18, 2025

I think you need to use the VALUE - not the label in the expression

Meaning "Adhoc" is the label, and "A" is the value

New Participant
April 18, 2025

I was wondering that.  Let me try that and see.