2 Replies Latest reply: Jun 19, 2010 7:07 AM by Ashwin Pagare RSS

    using if condition in Expression

    Raghavendra Suryakumar

      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