Calculate LMTD Sales.

[#1]

Hi Folks,

                    Wish u Happy New Year  2014 to Every one.

I want to Calculate Last month till date means. If I Select Jan-2014. I want to Calculate 01-Dec-2013 to 02-Dec-2013.

The Field Values are CalendarDate, CalendarMonth, CalendarYear, GrossAmt as Sale amount

Thanks and Regards,

Sakthivel.S

[jagan]

Hi,

Try this expression

=Sum({<CalendarDate={'>=$(=MonthStart(Today(), -1))<$(=Today())'}, CalendarMonth=, CalendarYear=>} [Sale amount])

Hope this helps you.

Regards,

Jagan.

[#3]

Hi Jegan,

    Thanks for your response. But the result showing if i select Jan 2013 . It Shows 01-Dec-2013 to 03-Dec-2013. But i am asking to Select Jan 2014 .  it should show 01-Dec-2013 to 03-Dec-2013

Regards,

Sakthivel

[#4]

=Sum({<CalendarDate={'>=$(=MonthStart(Today(), -1))<$(=Today())'}>} [Sale amount])

use this ..

[tresesco]

Could you post a sample app?

[miikkaqlick]

Try this:

=Sum(

     {<

     CalendarDate={'>=$(=MonthStart(Addmonths(Today(),-1)))<$(=AddMonths(Today(),-1))'},

     CalendarMonth=,

     CalendarYear=

     >}

[Sale amount])

Br,

Miikka

[#7 · Accepted solution]

Dear Friends,

     Thanks you all for response

Correct Answer : =Sum({< CalendarYear=, CalendarMonth=,  CalendarDate={'>=$(=MonthStart(Max(CalendarDate), -1))<=$(=MonthEnd(Max(CalendarDate), -1))'}  [Gross amt])