Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, I'm stuck with a problem, any help is welcome
The problem is when I'm trying to do the expression right. I need to show the sum of the mount from every monday from the last month uploaded, so, it will show that sum from that mount every monday, so numbers will change..
Example last month was march: all mondays were 2, 9, 16, 23 and 30.
So, if day=2 then will show x mount, if day=6 then will show y mount, and so on...
As you can see the problem it is in the second column, the expression is:
Sum({$< [Day]={$(=num(weekday([Day] &'/'& MID(Date,4,10))))} ,Yearr={'$(=Max(Yearr))'}>}[Mount])/1000000
But this [Day]={$(=num(weekday([Day] &'/'& MID(Date,4,10))))} it doesnt work
I need to think one thing in logic, how can I associate the idea of whether it is Monday, so what separates the paydays of the month that are Monday?
Any ideas how to relacionate this or change the problem logic? thanks.
Do you have a weekday field in the script? You might already have that information in your calendar? I am not sure how you plan to use it, but it might be available to you.