Change date by set analyse

[Larsstoel]

Good afternoon,

I am trying to write a formula that picks a different date for part of my formula. Unfortunately, this is not quite successful yet.

The date field I am using is uiterste_besteldatum. I filter in the app by filters based on year(uiterste_besteldatum) and week(uiterste_besteldatum). This gives me 7 dates to each other in the columns of my multi KPI (dimention).

Now I want to add values for some of the departments under the date selected and some of the departments should have the dates from the day after come under that date. I have written the formula the way below, it just does not work yet. Is there anyone who can help me? Thanks in advance!

sum({<afdeling = {'late dienst'}>} Geplande_uren)
+
Sum({<[Uiterste_besteldatum] = {"=date([Uiterste_besteldatum]+1)"}, afdeling = {'vroege dienst'}>} Geplande_uren)

[Vegar]

Could it be this you are trying to do?

sum({<afdeling = {'late dienst'}>} Geplande_uren)
+
Sum({<[Uiterste_besteldatum] = {"='$(=date([Uiterste_besteldatum]+1))'"}, afdeling = {'vroege dienst'}>} Geplande_uren)

[Larsstoel]

Hi Vegar,

Thank you for your answer.
When i try to use your suggestion i seems like te formula only does the part before the + Do you have another suggestion? 

Thank you!