Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have recent 3 years sales data, I'm trying to sum up all sales before August (current month) in these years. My function is:
Sum({<Month={"<(=month(today()))"}>}Sales)
The result is 0, I have no idea what's wrong. Any ideas?
Thanks in advance!!
This works good.
Well, then for test try Sum({$<Month={'$(=Month(AddMonths(Today(), -1)))'}>} Sales)
If you resolved the issue, please close this thread.
No it's not solved. I think William is only trying to test a comparison.
Works good as well.
Hi Sunny, could you please help on this?
May be adding a dollar sign might resolve the issue
Sum({<Month = {"<$(=Month(Today()))"}>}Sales)
no, the result is still 0
Maybe make your requirement clearer?
You replied "this works good" on two comments, which leads everyone to interpret them as working solutions. What worked and what didn't?
May be create a new field in the script like this
Num(Month(Date)) as NumMonth
and then try this
Sum({<NumMonth = {"<$(=Num(Month(Today())))"}>}Sales)