formular is not working

peisenrot — Tue, 18 Jul 2023 11:31:27 GMT

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

Re: formular is not working

BrunPierre — Tue, 18 Jul 2023 19:56:56 GMT

Hi, the set modifier is to be like this.

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

topic Re: formular is not working in App Development

formular is not working

Re: formular is not working