Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need to have last month only and this month only sales as 2 different columns in the same chart. I tried using add months concept..
any sugg
May be this?
HI
Try like this
Sum({<Date= {">=$(=Date(MonthStart(Today(),-1),'DD/MM/YYYY')) <= $(=Date(Floor(MonthEnd(Today())),'DD/MM/YYYY'))"}>}Sale)
i tried this Sum({<[Month]={'$(=Max(Month)-1)'}>}Sales) .. but my output is 0
Try like this
=Sum({<[Month]={'$(=Month(AddMonths(Today(),-1)))'}>}Sales)
hi mayhil,
it should not be based on today .. for ex: if iam selecting 02 it should show 01 and if i select month 03 it should show 02
Can you share a sample app to work on?
Hi
Try like this
=Sum({<[Month]={'$(=Max(Month)-1)'}>}Sales)
Note thtat: =Max(Month)-1 wil return 11 (Number format), if your month is in number format, it will work.
Otherwise,
Try like this
=Sum({<[Month]={"$(=Month(Date#(Max(Month)-1,'MM')))"}>}Sales)
HI
Try this
Current Month : Sum({< Month= {"$(=Month(AddMonths(Max(Date_Field),0)))"}>}Sales),
Previous Month: Sum({< Month= {"$(=Month(AddMonths(Max(Date_Field),-1)))"}>}Sales),
Careful with date formats