3 Replies Latest reply: Mar 17, 2016 5:18 AM by PAUL YEO RSS

    Convert Flag table more dynamic by using SET.

    PAUL YEO

      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