Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
As mentioned above, you haven't included the *-1 in the colour expression to finish of the simulation.
The colour expression evaluates separately from your main expression and is therefore still calculating a positive number.
I've just tested it and works perfectly for me.
Example for colour expression:
if(-1*if(
(
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000/Rate)
/
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/1000/Rate)
)
>1,1,
(
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000/Rate)
/
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/1000/Rate)
)
) >0 ,'#d01919','#545352')
