Hi,
I am trying to count the number of items that are doing better compared to the previous year. I have two variables set up as follows which shows the total sales for the respective years:
v1)=num(sum(AGGR(SUM({<FiscalYear={2016}>}SLL_PriceExc),[Item Number])),'#.')
v2)= num(sum(AGGR(SUM({<FiscalYear={2015}>}SLL_PriceExc),[Item Number])),'#.')
I tried to use the following formula but it did not give any results:
=num(Count(DISTINCT( if (v1>v2,[Item Number]))))
Any ideas?
Thanks
Shamit
