Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression not working fine :-
if(GetSelectedCount([Pls select 901st Dim])<1,
Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
,
$(vMoneyFormatK)),
Money(
fabs(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
)
,
$(vMoneyFormatK))
)
Hope some can advise me.
Paul
Enclosed my QVW