1 of 1 people found this helpful
It looks like the text in the images does not match the text in your calculation. To make sure you use the same text in your formulas and avoid typing them out try selecting the alias option then copying the original text into your formula. If you only need to add quick labels and will not need to reference this in other calculations a quick option might be to create groups from the original Description field.
You may also try and just use CONTAINS() to grab the "4 to 5" from each dimension to simplify it?
IF CONTAINS([DIM],"4 to 5") Then "X"
ELSEIF CONTAINS([DIM2], "4 to 5") then "X"
This worked and thank a ton Mark.
This worked in terms of checking my calculation values are captured correctly or not.
Thanks a ton Kent.