3 Replies Latest reply: Jun 28, 2018 12:44 PM by Sunny Talwar RSS

    Prior Month Data

    Richard Cheiw

      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?