Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I don't know why the following expression doesn't work properly:
=aggr(sum({<MYMONTH={ "<= $(=only(PURCHASE_MONTH))"}, MY_YEAR ={"=$(CURRENTYEAR)-1)"}>} Purchase_amount), Supplier_code)
What I would have is the sum of purchase amount till the selected month (MY_MONTH), but for the previuos year (2011).
It doesn't recognize the ..{"= $(currenyear)-1).... expression. The result is nothing.
The following expression works properly
=aggr(sum({<MYMONTH={ "<= $(=only(PURCHASE_MONTH))"}, MY_YEAR ={"= $(CURRENTYEAR)"}>} Purchase_amount),Supplier_code)
I really don't understand. Help please
Thanks in advance
You have DateField?If so better go with that.
Example:
=aggr(sum({<DateField={">=$(=YearStart(AddYears(Max(DateField),-1)))<=$(=AddYears(Max(DateField),-1
))"},MYMONTH=,MY_YEAR>} Purchase_amount), Supplier_code)
or based on your Expression it will be
=aggr(sum({<MYMONTH={ "<= $(=only(PURCHASE_MONTH))"}, MY_YEAR ={$(=$(CURRENTYEAR)-1))}>} Purchase_amount), Supplier_code)
Hi
Try like this
=aggr(sum({<MYMONTH={ "<= $(=only(PURCHASE_MONTH))"}, MY_YEAR ={"=$(AddYears(CURRENTYEAR - 1)"}>} Purchase_amount), Supplier_code)
Regards
Iyyappan
You have DateField?If so better go with that.
Example:
=aggr(sum({<DateField={">=$(=YearStart(AddYears(Max(DateField),-1)))<=$(=AddYears(Max(DateField),-1
))"},MYMONTH=,MY_YEAR>} Purchase_amount), Supplier_code)
or based on your Expression it will be
=aggr(sum({<MYMONTH={ "<= $(=only(PURCHASE_MONTH))"}, MY_YEAR ={$(=$(CURRENTYEAR)-1))}>} Purchase_amount), Supplier_code)
Hi
I think this shoud work:
=Aggr(sum({<MYMONTH={"<=$(=Only(PURCHASE_MONTH))"}, MY_YEAR ={"=$(=CURRENTYEAR-1)"}>} Purchase_amount), Supplier_code)
Hope that helps
Jonathan
Hi Iyyappan V,
it doesn't work. I get the message Error dimensions
Thanks anyway
Thanks very much Celambarasan
and thanks to anyone has spent his time to help me.
stefan