2 Replies Latest reply: Dec 16, 2015 12:10 PM by Peter Cammaert RSS

    More SET Expression TOGETHER

    Mayuri Nandu

      HI,

       

      Can we write if condition in SET analysis

       

       

       

      =if(Match(Particulars_No,3,4,5),FABS(if(Particulars_No = 5,FABS(Above([Prev Prev Month YTD],1) + Above([Prev Prev Month YTD],2)),

      if(Particulars_No = 15,(Above([Prev Prev Month YTD],1) + Above([Prev Prev Month YTD],2) + Above([Prev Prev Month YTD],3) + Above([Prev Prev Month YTD],4) +  Above([Prev Prev Month YTD],5) +  Above([Prev Prev Month YTD],6) +  Above([Prev Prev Month YTD],7)),

      if(Particulars_No = 17,(Above([Prev Prev Month YTD],12) - Above([Prev Prev Month YTD],2)),

      if(Particulars_No = 20,(Above([Prev Prev Month YTD],1) - Above([Prev Prev Month YTD],3)),

      if(Particulars_No = 23,(Above([Prev Prev Month YTD],1) - Above([Prev Prev Month YTD],3)),

      if(Particulars_No = 29,(Above([Prev Prev Month YTD],1) + Above([Prev Prev Month YTD],2) + Above([Prev Prev Month YTD],3) + Above([Prev Prev Month YTD],4) +  Above([Prev Prev Month YTD],5)),

      if(Particulars_No = 30,(Above([Prev Prev Month YTD],7) - (Above([Prev Prev Month YTD],1))),

      SUM({<FYear = {$(vMaxYear)},FIN_MNTH_NUM = {$(vOctMonth)},Particulars=,Particulars_No=,Notes=>} (OPENING + (TRANSACTIONS))))))))))),

      if(Particulars_No = 5, FABS(Above([Prev Prev Month YTD],1) + Above([Prev Prev Month YTD],2)),

      if(Particulars_No = 15,(Above([Prev Prev Month YTD],1) + Above([Prev Prev Month YTD],2) + Above([Prev Prev Month YTD],3) + Above([Prev Prev Month YTD],4) +  Above([Prev Prev Month YTD],5) +  Above([Prev Prev Month YTD],6) +  Above([Prev Prev Month YTD],7)),

      if(Particulars_No = 17,(Above([Prev Prev Month YTD],12) - Above([Prev Prev Month YTD],2)),

      if(Particulars_No = 20,(Above([Prev Prev Month YTD],1) + Above([Prev Prev Month YTD],3)),

      if(Particulars_No = 23,(Above([Prev Prev Month YTD],1) + Above([Prev Prev Month YTD],3)),

      if(Particulars_No = 29,(Above([Prev Prev Month YTD],1) + Above([Prev Prev Month YTD],2) + Above([Prev Prev Month YTD],3) + Above([Prev Prev Month YTD],4) +  Above([Prev Prev Month YTD],5)),

      if(Particulars_No = 30,(Above([Prev Prev Month YTD],7) - (Above([Prev Prev Month YTD],1))),

      SUM({<FYear = {$(vMaxYear)},FIN_MNTH_NUM = {$(vOctMonth)},Particulars=,Particulars_No=,Notes=>} (OPENING + (TRANSACTIONS)))))))))))