Using a date variable within a set analysis

DutchHans — Fri, 15 Nov 2024 23:14:28 GMT

I have a constant date in a set analysis formula as stated below:

Sum({1<AdmCode-={20,22},LoontijdvakNr={2},GeaccordeerdVT={"<=5-03-2020"}>}Bedrag)

What I want is to replace the date with a variable. Note that there is also a comparison "<=" (smaller or equal to) in the equation.

I know that I have to use $(VariableName) but I do not succeed in a workable solution.

Re: Using a date variable within a set analysis

PradeepK — Wed, 27 Jan 2021 16:20:35 GMT

Sum({1<AdmCode-={20,22},LoontijdvakNr={2},GeaccordeerdVT={"<=$(=vName)"}>}Bedrag)

where vName is your variable.

Refer to my reply from this post - Link