Please help me in figuring out the below issue.
RED HYPHEN '-' when no items selected on the filter
1) When no items selected on the filter, the KPI box should have Gray hyphen '-'.
2) If anyone of the items selected from the filter, based on the sign of the value, it should display either Red or Green colour.
for a value less than 0 it should be Red
and for a value greater than 0 it should be Green
and for no value, it should be Gray hypen -
Please see what I did so far.
Written condition on KPI Box : if(GetSelectedCount(Campaigns)=0,'-',[B]-[A])
In conditional colour:
Written condition like this: = if([B]-[A]<0,Red(),Green())
Please help me to fix Red hyphen issue here