Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check your systems calendar/date.
Your are still living in last year. 🙂
Why in the world would it be 12/1/11?!
Another possibility:
today() is equivalent to today(2), which means: Date when the document was opened
I assumed that you have opened the document after Jan 1st, but maybe you have still kept it open since last December?
Brilliant!
Now I understand why I do not get good data when I keep my application open over night or over a weekend.
Thanks a lot.
HAHA! That is why it says today=12/15. It stays open on the server.
Thank you so much,
Kristy