6 Replies Latest reply: Aug 3, 2017 8:33 AM by kushal chawda RSS

    changing the expression

    naveen kumar

      Hello All,

       

       

            is it possible to write below expression in different way without using Total function

      Sum({<[YEAR]={$(=max([YEAR])-1)}>}total<Part,[PLANT NAME],FISCYEAR>Value)



      i tried this but i am getting null values

      aggr(nodistinct  Sum({<[YEAR]={$(=max([YEAR])-1)}>}Value),Part,[PLANT NAME],FISCYEAR)




      can suggestion .....


      thanks