Issues with Guage Chart

[raghavsurya]

Hi,

We have created a guage chart representation for What-iff tab to depict the What-if Revenue movement. I am trying to give a condition in the Text color option of the expression to show in green if What-if Rev increases the present revenue else in red. Its not working.....

can you please suggest if the condition I have given is correct.

= if( num (((if (Year='2011', sum(FAmount)) & if(Year='2010',sum( AAmount))) * (1 + VRev/100)))> num (if (Year='2011', sum(FAmount)) & if(Year='2010',sum( AAmount))), Green(255), Red(255))

I am attaching the screenshot of What-if sheet.

Thanks and Regards,

Raghav