using if condition in Expression

[raghavsurya]

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

[#2]

hi ,

I think there is no such issue with expression , can u send a sample qvw file for same

ashwin

[#3]

hi ,

I think there is no such issue with expression , can u send a sample qvw file for same

ashwin