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 .....