This content has been marked as final. Show 2 replies
I am building a guage chart wherein I need to get the % of Acutal Revenue against the Projected Revenue if the year is 2009. In the Sales Table I have the following columns.
2, Actual Sales
3. Actual Services
4. Projected Sales
5. Projected Services.
I have defined the expression as below
(sum(if(Year='2009',([Actual Sales])+ [Actual Service])))/(sum(if(Year='2009',([Projected Sales]+ [Projected Services]))))
But this expression is not returning any values.
Can anybody please point out the issues in the expression.
Thanks and Regards,