Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to sum the last 30 days of our business. I typed the following set expression and I get a 0 balance.
Any help would be appreciated. Thanks
*Edited*
You could try:
30 days from max GamingDt date :
Sum({<GaminDt = {">=$(=Date(Max(GamingDt)-30))"} >} TotalTheoWin)
30 days from today:
Sum({<GaminDt = {">=$(=Today()-30"} >} TotalTheoWin)
I tried it and it didn't work. At least when I typed it my way, I got this on the bottom.
I've edited post above. Please give a try.
So I used some of your formulas to modify my formula and to make the following:
30 Days from Today:
Sum({<GaminDt = {">=$(=Date(Max(GamingDt)-30))"} >} TotalTheoWin)
Now it's showing the total amount as if the set expression is not there but it's not a 0.
I appreciate you taking the time to help.
I noticed there was an error in my previous formula. The GamingDt was spelled incorrectly. I used the following formula and I got a 0 in the total again.
Sum({<GamingDt = {">=$(=Date(Max(GamingDt)-30))"} >} TotalTheoWin)
Are you able to give us a mockup? I'm worry about GamingDt field format.
The set expression I used above is the one I am currently using. Is there anything else you need?
What is GamingDt format?
GamingDt is in Date format.