Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Table 1 Expression Can display Jan till Nov Revenue :-
(Sum({<rEVENUE={rEVENUE}>}Amount))
Table 2 Expression Can only display Jan till Aug Revenue :-
Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1, $(ColumnDim108)))
,
$(vMoneyFormatK))
Above expression is working fine previouly, Suddenly it cannot work.
Notice that Table 1 and Table 2 expression label display as "Jan till Aug 2019 rEVENUE"
How to make it display as "Jan till Nov 2019 rEVENUE"
Hope some one can advise me.
Paul
Hi All
Enclosed my QVW
Paul