Weekly Challenges

Awaleczek · ‎09-04-2023

If you end up replacing that empty high value with a number like "999999999999" have a look at this one. It's unlikely that such a value is ever reached but you can never be 100% certain :)

Spoiler

IF [Value] > [Amber Low] and [Value] <= [Amber High]
THEN 'Amber'
ELSEIF [Value] > [Green Low] and ([Value] <= [Green High] OR IsNull([Green High]))
THEN 'Green'
ELSE 'Red'
ENDIF

IF [Value] > [Amber Low] and [Value] <= [Amber High]THEN 'Amber'ELSEIF [Value] > [Green Low] and ([Value] <= [Green High] OR IsNull([Green High]))THEN 'Green'ELSE 'Red'ENDIF