Two selections

[#1]

Hi Community

Support me please. Any help is important

I have two selections

29/01/2012

12/02/2012

Of which I need to bring the maximum month year -1, (I need information from the previous month Jan 2012) I have the following statement

sum ({$ <[Month Year] = {'$ (= MonthName (AddMonths (max (Date), -1)))'}, {ClaseCoste = '520065 '}>} CantidadORD)

= sum ({$ <ClaseCoste = {'520065 '},

[Month Year] = {'$ (= MonthName (AddMonths (max ([Month Year]), -1)))'},

year =

>}

CantidadORD)

I can suggest some judgment.

Thanks for your support and greetings

[MayilVahanan]

Hi

Try like this

=Sum( {< Monthyear = {'$(= MonthName (AddMonths (max (Date), -1)))'}, ClaseCoste = {520065}>}Sales)

and make sure that . Both = MonthName (AddMonths (max (Date), -1)) and Monthyear are same format

Hope it helps

[#3]

Thanks for the support

Sum( {< [Mes Año] = {'$(= MonthName (AddMonths (max (Fecha), -1)))'}, ClaseCoste = {520065}>}CantidadORD)

Thus was my judgment and achievement data.

my date format is:

Date 29/01/2012

month Jan 2012

year 2012

regards

[MayilVahanan]

Hi

     fecha is date, am i correct? And did you get the expected result?