3 Replies Latest reply: Mar 11, 2016 7:10 PM by Yeo Poh sai RSS

    How to modify my expression from sum to Pick ( Match ?

    Yeo Poh sai

      Hi All

       

       

      Chart 1 expression okay for sales ( when click on step 1 ) :-

       

       

      money(pick(

      match([Pls select 67 Dim],'rEVENUE','sales','cost','profit','eXP','n_PRO'),

      Sum({<$(ColumnDim67)={$(ColumnDim67)}>}Amount)/$(Columndim89)/1000,

      Sum({<Year={'>$(=year(today())-2)'}>} sales/$(Columndim89)/1000),

      Sum({<Year={'>$(=year(today())-2)'}>} cost/$(Columndim89)/1000),

      Sum({<Year={'>$(=year(today())-2)'}>} profit_amt/$(Columndim89)/1000),

      Sum({<$(ColumnDim67)={$(ColumnDim67)}>}Amount)/$(Columndim89)*-1/1000,

      Sum({<$(ColumnDim67)={$(ColumnDim67)}>}Amount)/$(Columndim89)/1000),

      $(vMoneyFormatK))

       

       

      Chart 3 expression as below , work fine too :-

       

       

      Sum( {<Year={'>$(=year(today())-2)'}, nET_PROFIT={'nET_PROFIT'}>}Amount )

       

       

      When i press Step 2 , how to make Chart 4 look like chart 3 ?

       

       

      My imagine expression for chart 4 as below :-

       

       

      money(pick(

      match([Pls select 67 Dim],'rEVENUE','sales','cost','profit','eXP','n_PRO'),

      Sum({<$(ColumnDim67)={$(ColumnDim67)}>}Amount)/$(Columndim89)/1000,

      Sum({<Year={'>$(=year(today())-2)'}>} sales/$(Columndim89)/1000),

      Sum({<Year={'>$(=year(today())-2)'}>} cost/$(Columndim89)/1000),

      Sum({<Year={'>$(=year(today())-2)'}>} profit_amt/$(Columndim89)/1000),

      Sum({<$(ColumnDim67)={$(ColumnDim67)}>}Amount)/$(Columndim89)*-1/1000,

      Sum( {<Year={'>$(=year(today())-2)'}, nET_PROFIT={'nET_PROFIT'}>}Amount/1000),

      $(vMoneyFormatK))

       

       

      But it never work , hope some one can advise me.

       

       

      Paul