Hi all,
In our business environment we book orders which gives us a certain amount of revenue.
We would like to see how this revenue is growing per week, where the reference day is saturday.
I would like to have a table like this:
| Month | First sat | Second sat | Thirds sat
| Fourth sat
| Fifth sat
|
|---|
| 1 | 10000 | 20000 | 30000 | 40000 |
|
| 2 | 15000 | 30000 | 45000 | 60000 |
|
The expression is should be something like:
sum(if(Bookdate <= (date of 1/2/3/4/5 saturday in a month) Revenue))
In the sample document I have made an example of what I would like to see, but in my opinion the expression I use is way to complex.
Is it possible to get the ' date of 1/2/3/4/5 saturday in a month' with a variable or in another way?
Many thanks.
Regards,
Henco
