Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The following syntax works when I extract amount more than 100,000 & smaller than -100,000, current year, current month:
num(sum({<Amount={">10000000<-10000000"},JDE.Year={"$(=year(today()))"},JDE.Month={"$(=month(today()))"}>}Amount/100),'#,##0')
However, I am having trouble extracting prior month by adding '-1':
num(sum({<Amount={">10000000<-10000000"},JDE.Year={"$(=year(today()))"},JDE.Month={"$(=month(today())-1)"}>}Amount/100),'#,##0')
No data returned.
Any idea what I did wrong?
Try this
Num(Sum({<Amount = {">10000000<-10000000"}, JDE.Year = {"$(=Year(Today()))"}, JDE.Month = {"$(=Month(AddMonths(Today(), -1)))"}>} Amount/100), '#,##0')
That totally works.
Thank you Sunny!!
Super