3 Replies Latest reply: Dec 28, 2017 5:22 AM by Noor Mazlina RSS

    Expression in bar chart

    Nikita Agrawal

      Hi ,



      I am trying to write an expression in a bar and line combo chart.


      when I am writing below expression the value is coming different in the chart and different in Straight table.


      Expression in Straight table- I have Region as a dimension in staright table which is having value apac and emeia.

      Premium value : NUM(ROUND(SUM({<Month=,TDimMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}TSummary.Value)))



      Expression in Bar Chart

      Premium Value : Sum({<Month=,TMonth.PrevFiscalMonth=P(TMonth.FiscalMonth)>}if(Region='APAC',TSummary.Value))



      Please help how can i write the expression in bar chart which will give the same value as in straight table.