Calculated field with if..then, not returning as expected | Community
Skip to main content
Level 2
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!

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
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

Level 2
April 18, 2025

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