Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression work fine :-
Sum({<year = {$(=Max(year) - 1)} , month = {"<=$(=Max({<year={$(=Max(year) - 1)}, sales = {'*'}>} month))"}, rEVENUE={"rEVENUE"} >} Amount*1)/Rate/1000
I try to add sum(aggr into above expression :-
sum(aggr(
Sum({<year = {$(=Max(year) - 1)} , month = {"<=$(=Max({<year={$(=Max(year) - 1)}, sales = {'*'}>} month))"}, rEVENUE={"rEVENUE"} >} Amount*1)/Rate/1000
))
it display null value.
Paul
my QVF
You have to specify dimesion for the aggr() function.
Hi Robert
Thank you very much , it work now :-
sum(aggr(
Sum({<year = {$(=Max(year) - 1)} , month = {"<=$(=Max({<year={$(=Max(year) - 1)}, sales = {'*'}>} month))"}, rEVENUE={"rEVENUE"} >} Amount*1)/Rate/1000,SOURCE
))