Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
ENclosed my QVW