Skip to main content

Hey All,

I'm trying to get this formula to produce one of three outcomes based on a products variance % from its target FOB, but for some reason it is not producing anything. I have used this formula multiple times successfully on other tables, but for some reason it is not working for this case. I have rewritten it a couple times and have checked the reference field to see if there are any issues and still can't figure out why its not producing an outcome.  

 

Feel free to ask any clarifying question. Any help will be greatly appreciated!

- Erich

 

IF(
{Precost FOB % Variance} = BLANK(), BLANK(),
IF({Precost FOB % Variance} <= -0.05, "RED: More than 5% off target",
IF(AND({Precost FOB % Variance} >= -0.0499, {Precost FOB % Variance} <= 0), "YELLOW: 0% - 4.99%",
IF({Precost FOB % Variance} > 0, "GREEN: Meeting or Exceeding target")
)
)
)

Hmm, could you provide screenshots of the relevant fields?  Your formula works fine when I tried testing it.  I also tried breaking it with a lookup and it seems fine:

Hmm, could you provide screenshots of the relevant fields?  Your formula works fine when I tried testing it.  I also tried breaking it with a lookup and it seems fine:


Hey Adam,

See the screenshot below. I appreciate the assistance. 

- Erich

 

Not sure how this resolved the issue, but once I turned off and reset the formula formatting, it started working properly. 

Thank you for the help!

- Erich

 

Terms & ConditionsAccessibility statement