I've read a few posts here in the Dojo, and also read this Knowledge Base article: Sample Beast Mode Calculations: Card Element Transforms
but cannot get this to work. It seems that the examples I am finding are far more complex than I need - maybe I'm missing something simple.
The logic I am trying to apply for a Summary Number is as follows:
CASE
WHEN `Gap` > 0 Then `Gap` [green text with green up arrow]
WHEN `Gap` < 0 Then `Gap` [red text with red down arrow]
ELSE `Gap` [black text with no arrow]
END
Here is a short video overview of what I'm asking for help with.