1 Reply Latest reply: Dec 12, 2017 10:37 PM by Yeo Poh sai RSS

    How to modify expression from YTD amount to total accumulated amount ?

    Yeo Poh sai

      HI All,


      my below expression working fine :-


      Money(

      Sum(Aggr(SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))

      ,

      $(vMoneyFormatK))


      I like to modify the below expression instead of compute the YTD amount , i like to change to accumulation :-


      I have try this work , but it only give revenue amount , i need it to be dynamic:-


      (Sum({<rEVENUE={rEVENUE}>}Amount))


      I have try the below it does not work. ( As it return null value)


      (Sum({<$(ColumnDim108)={$(ColumnDim108)}>}Amount))


      Hope some one can help me.


      Paul Yeo