"IF" Field Calculation Help | Community
Skip to main content
O
OmahaOmaha
Level 4
November 18, 2024
Question

"IF" Field Calculation Help

  • November 18, 2024
  • 2 replies
  • 451 views

Hi All,  was hoping to get a little insight into why a portion of my IF formula is populating.  WF accepts the code I created, however when the reference field has a score of 100, the formula I created doesn't display the text that should be displayed from the calculation, "Active Dev. Up To Date"

 

Here's my current calculation.

IF({DE:AD Completion Score}<50,"Active Dev. Less Than 50%",IF({DE:AD Completion Score}>50,"Active Dev. 50% Complete",IF({DE:AD Completion Score}=100,"Active Dev. Up To Date")))
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

skyehansen
Community Advisor
skyehansenCommunity Advisor
November 19, 2024

If I had to guess, I would say the reason that the last part (100) isn't being read is because 100 is greater than 50%.So it is fulfilling the middle part of your statement ("50% complete") and doesn't get a chance to get all the way to what to do if it's 100% complete.

 

You could try to reverse the entire thing. "IF 100% do X, if >50 do Y, if <50 do Z". Or maybe just change the middle part of the statement to IF <100 instead of IF >50.

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
November 19, 2024

Hi @omahaomaha 

I like Skye's suggestion of starting with the =100. 

As she pointed out, if you're never reaching the third condition because if the number is greater than 50, it ends with the second condition. 

Funnily your condition makes it so that if the completion score is 50 - the calculation shows N/A (because there's no condition).
You can use 2 conditions to fix this

  1. is Active Dev = 100?
  2. is Active Dev > 50
IF( {DE:AD Completion Score}=100, "Active Dev. Up To Date", IF( {DE:AD Completion Score}>=50, "Active Dev. 50% Complete", "Active Dev. Less Than 50%" ) )
Terms & ConditionsAccessibility statement

Loading footer...