It is possible you may need to write the formula as
IF SUM([Y/Y Actual])>= 1 THEN
ELSEIF SUM([Y/Y Actual]) < -1 THEN
Also, if you post a packaged workbook or some sample data that is similar to what you have, this problem would be easier to troubleshoot.
Well, I tried that too. The Y/Y Actual is already a calculated field, so I cannot aggregate over an agg. function.
I have attached a sample workbook in which I duplicated my problem.
Sample Wkbk.twbx.zip 1.4 MB
You'll need to multiply your profit ratio in your color calculation by 100 to get the percentages. Once you've done that, you can assign colors to the discrete values that are the result of your calculation. I attached my edits to your workbook below.
Hi Dylan, worked on my original source perfectly fine ! Thanks so much!