Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Your first expression should be equivalent to
=sum ({$<INFOTYPE={'REAL','UM6'}>}[SALES MXN]/TC) / 1000
i.e. you can set multiple values within a set element. Does this result in correct values?
Then I would assume last years sales should be
=sum ({$<INFOTYPE={'REAL','UM6'}, Year= {$(=only(Year)-1)}, Month={"<=$(=max(Month))"} >}[SALES MXN]/TC) / 1000
Hope this helps,
Stefan
Your first expression should be equivalent to
=sum ({$<INFOTYPE={'REAL','UM6'}>}[SALES MXN]/TC) / 1000
i.e. you can set multiple values within a set element. Does this result in correct values?
Then I would assume last years sales should be
=sum ({$<INFOTYPE={'REAL','UM6'}, Year= {$(=only(Year)-1)}, Month={"<=$(=max(Month))"} >}[SALES MXN]/TC) / 1000
Hope this helps,
Stefan
Wow!! it works perfectly, excelent once again you helped me a lot.
Thank you very much Swuehl!!!