Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dear Friends,
Thanks you all for response
Correct Answer : =Sum({< CalendarYear=, CalendarMonth=, CalendarDate={'>=$(=MonthStart(Max(CalendarDate), -1))<=$(=MonthEnd(Max(CalendarDate), -1))'} [Gross amt])
Hi,
Try this expression
=Sum({<CalendarDate={'>=$(=MonthStart(Today(), -1))<$(=Today())'}, CalendarMonth=, CalendarYear=>} [Sale amount])
Hope this helps you.
Regards,
Jagan.
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
=Sum({<CalendarDate={'>=$(=MonthStart(Today(), -1))<$(=Today())'}>} [Sale amount])
use this ..
Could you post a sample app?
Try this:
=Sum(
{<
CalendarDate={'>=$(=MonthStart(Addmonths(Today(),-1)))<$(=AddMonths(Today(),-1))'},
CalendarMonth=,
CalendarYear=
>}
[Sale amount])
Br,
Miikka
Dear Friends,
Thanks you all for response
Correct Answer : =Sum({< CalendarYear=, CalendarMonth=, CalendarDate={'>=$(=MonthStart(Max(CalendarDate), -1))<=$(=MonthEnd(Max(CalendarDate), -1))'} [Gross amt])