Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
1, Year
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,
Raghav
hi ,
I think there is no such issue with expression , can u send a sample qvw file for same
ashwin
hi ,
I think there is no such issue with expression , can u send a sample qvw file for same
ashwin