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

paulyeo11 — Wed, 13 Dec 2017 03:36:23 GMT

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

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

paulyeo11 — Wed, 13 Dec 2017 03:37:56 GMT

ENclosed my QVW

topic How to modify expression from YTD amount to total accumulated amount ? in App Development

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

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