3 Replies Latest reply: Mar 17, 2016 5:18 AM by Yeo Poh sai RSS

    Convert Flag table more dynamic by using SET.

    Yeo Poh sai

      Hi

       

       

      My Objective is to make my Flag table more dynamic by using SET.

       

       

      My flag table 1 :-

       

       

      Expression :-

      money(

      Sum (if($(ColumnDim3), sales)/1000/$(Columndim89))

      , $(vMoneyFormatK))

       

       

      Dimension :-

       

       

      =if(

      aggr(

      (Sum (if($(ColumnDim3), sales)) - Sum (if($(ColumnDim4), sales)))  / Sum (if($(ColumnDim4), sales))

      , $(ColumnDim101)) <= $(iDiffValues) / 100

      , $(ColumnDim101))

       

       

      I try convert to SET table 2 :-

       

       

      Expression :-

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000)

       

       

      I don't know how to convert dimension to SET ( Table 2) , when i turn on current mth and yr , table not working .

       

       

      Hope some one can advise me.

       

       

      Paul