Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
Sum({<Month = {"$(=month(addmonths(Max(Date),-1)))"},Year={'$(=Year(addmonths(Max(Date),-1)))'} ,Date=>}Sales)
Try:
Sum({<Month = {"$(=month(addmonths(Max(Date),-1)))"},Year={'$(=Year(addmonths(Max(Date),-1)))'} ,Date=>}Sales)
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?
Hi,
Have a look at the attached exmaple.
Hope this will clear your doubt.
Regards,
Kaushik Solanki