formular is not working

[peisenrot]

Hello,

I would like to use the formular 

Sum({<Dataset={'People'},[Period.Date]={">=01/01/2023","<=$(MaxLoadFTE)"}>} Value) to sum up all Periods between 1st jan and the variable MaxLoadFTE which is 6/1/2023. it is using all starting 1st jan but not until 6/1/23. what is wrong here?

best regards

Pia

[BrunPierre · Accepted solution]

Hi, the set modifier is to be like this.

{">=01/01/2023<=$(MaxLoadFTE)"}>}