Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
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!