5 Replies Latest reply: Nov 2, 2012 11:46 AM by steve peroni RSS

    set analisys troubles

    steve peroni


      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