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")
)
)
)
