13 Replies Latest reply: Jan 4, 2012 6:32 PM by Kristy McGee RSS

    Set Analysis monthstart(today()) does not work in January

      I am currently using these formulas to pull the current month and previous mtd.  For January I am getting some crazy numbers. 

       

      Current Mtd:

       

      sum({<Tran Date]={">=$(=monthstart(today()))"}>}Fees)

       

      Previous month to date:

      sum({<Tran Date]={">=$(=monthstart(max(trandate),-1) & '<=' & Addmonths(max(trandate),-1))"}>}Fees)

      If someone could help me adjust these formulas to pull correctly, I would greatly appreciate assistance.

      Thanks,

      Kristy