Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below expression workinf fine :-
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/1000/Rate, SOURCE))
Below expression is not working fine :-
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1/Rate)/1000, SOURCE))
My question why i need to place the Rate after the ) and cannot place before that ?
Paul
my QV Doc