I should know this but I can't get it to work properly.
I want to sum sales data from today (vToday already calculated) until the 30th occurrence of a working days and only the when working days are equal below. Using the table below, the result should be 4099.
I use a normal calendar tables linked to a sales table. Something like: