3 Replies Latest reply: Feb 13, 2016 10:54 PM by PAUL YEO RSS

    Set Expression working in Table not work in chart ?

    PAUL YEO

      Hi All

       

       

      Table 1 Expression below , Display Amount RM 35K is correct :-

       

       

      money(

      SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=month)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1)/$(Columndim89)/1000,

      $(vMoneyFormatK))

       

       

       

       

      How to make below expression from chart 1 also display RM 35K same as Table 1 ?

       

       

      money(

      SUM({<year = {"$(=Max(year)-0)"},$(ColumnDim51)={$(ColumnDim51)}>}Amount*1/$(Columndim89)/1000)

      ,$(vMoneyFormatK))

       

       

      Now it display RM 140K, Hope some one can advise me.

       

      In my next post , i will post my QV Doc

       

      Paul