Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All I have below expression , return correct values :- '= money( SUM({}Amount*-1)/1000/$(Columndim89) , $(vMoneyFormatK)) Due to it does not display Total Sum , So I have modify the above expression with Aggr , but it return wrong value , May I know how to make it return correct value ? = money( Sum(Aggr(SUM({}Amount*1)/$(Columndim89)/1000, SOURCE)) , $(vMoneyFormatK)) Paul
Hi All
I have below expression , return correct value :-
money(
SUM({<year = {"$(=Max(year)-1)"},month={"<$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*-1)/1000/$(Columndim89)
, $(vMoneyFormatK))
Due to it does not display Total Sum , So I have modify the above expression with Aggr , but it return wrong value , May I know how to make it return correct value ? .
=
money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)/$(Columndim89)/1000, SOURCE))
, $(vMoneyFormatK))
Paul
my QV Doc
my QVF file