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.