1 of 1 people found this helpful
I would really like to see the data
What you are seeing is what happens when you never trigger the second clause in your case statement
I think you need to remove this from your case statement
else case ATTR([Required Direction of Travel of Indicator])
it would then become
ATTR([Required Direction of Travel of Indicator])
when 'Increase' then
if [1 yr DofT] = "Up" then "G"
elseif [1 yr DofT] ="Down" then "R" end
when 'Decrease' then
if [1 yr DofT] = "Up" then "Red"
elseif [1 yr DofT] ="Down" then "Green"
you may need to play with the snytax
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Glad to help out
If this has solved your issue please mark my response Correct to close the thread