addmonths and set analysis

[#1]

Hi guys,

I am stuck on something and since I'm new to set analysis I dont know how to procced. I have the following expression:

  Sum({<Month = {"$(=month(addmonths(Max(Date),-1)))"},Year=,Date=>}Sales)

The expression basically SUMS the previous months "Sales". This works perfectly but when I only have a years data. But when I have sales for more than a year (i.e there are multiple Feb (2012 &2013) it sums the sales for both years. I just want the previous months sales.

Any ideas?

Regarss

[Gysbert_Wassenaar · Accepted solution]

Try:

Sum({<Month = {"$(=month(addmonths(Max(Date),-1)))"},Year={'$(=Year(addmonths(Max(Date),-1)))'} ,Date=>}Sales)

[#3]

Thanks man,

Works like a charm.

How can i work on my set analysis? I know practice. But do you know of any material or forums other than this one?

[kaushiknsolanki]

Hi,

     Have a look at the attached exmaple.

     Hope this will clear your doubt.

Regards,

Kaushik Solanki