Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I am facing the issue in getting the data for the previous month and i have written the expression as to get the previous month closing inventory qty as current month opening inventory qty but the thing is i am not getting this instead i am getting 0 value
The expression which i have used is as shown below:
For Current Month :
sum({<CalendarMonthID={$(VCurrentCalendarFiscalMonth)}>}inventoryqty)
For Previous Month:
sum({<CalendarMonthID={$(Vcurrentcalendarfiscalmonth-1)}>}inventoryqty)
But still i am not able to get the exact value
Please help me on this as this is urgent.
Regards,
Smita
Hi,
Use this in getting the previous month.
Date(AddMonths(Date#(Today(),'YYYY-MM-DD'),-1), 'YYYY-MM-DD')
Regards,
Janzen
please find Month-Year(Jan-2012) in your application.
if not then calculate from Month
then in expression use below codes
Current Month
sum({<MonthYearField={$(=Date(Max(MonthYearfield),'MMM-YYY'))}>} amountfield)
previous MONTH
sum({<MonthYearField={$(=Date(addmonths(Max(MonthYearfield),-1),'MMM-YYY'))}>} amountfield)
hope this helps
thanks for the help ,i will try this and will let you know