topic Re: Change date by set analyse in App Development

Change date by set analyse

Larsstoel — Tue, 19 Dec 2023 15:59:13 GMT

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)

Re: Change date by set analyse

Vegar — Tue, 19 Dec 2023 16:14:24 GMT

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)

Re: Change date by set analyse

Larsstoel — Wed, 20 Dec 2023 08:41:54 GMT

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!