topic Re: why add sum(aggr into expression it return null value ? in App Development

why add sum(aggr into expression it return null value ?

paulyeo11 — Wed, 13 Apr 2016 07:10:02 GMT

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

Re: why add sum(aggr into expression it return null value ?

paulyeo11 — Wed, 13 Apr 2016 07:12:30 GMT

my QVF

Re: why add sum(aggr into expression it return null value ?

robert_mika — Wed, 13 Apr 2016 07:14:52 GMT

You have to specify dimesion for the aggr() function.

Aggr() function

Re: why add sum(aggr into expression it return null value ?

paulyeo11 — Wed, 13 Apr 2016 07:44:00 GMT

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

))