Parameterization error

[RichardRozgonyi]

Hello everyone,

I have the following issue that I cannot explain.
Can one of you please help me?

I have nested parameterized variables.
Version Windows Enterprise Nov 2025 Patch 2.

The result is 0 as long as I replace a parameter and write the same thing back in.

Formula output: $(vSollzeitmitArbeitsartStartJ(0,0,209))

vSollzeitmitArbeitsartStartJ : Sum({<$(vIgnore),Datum={"$(vStartJMaxToEndeMStartJMaxDatum($1,$2))"},ArbeitsartNr = {$3}>}SollZeit)

vIgnore : Jahr=,Monat=,Monat_Eindeutig=,Quartal=,Woche=,WocheJahr=,Wochentag=

vStartJMaxToEndeMStartJMaxDatum : >=$(=Date(YearStart(AddYears('$(vMaxD)',-($1)))))<=$(=Date(MonthEnd(Addmonths(Yearstart(Addyears('$(vMaxD)',-($1))),-($2)))))

vMaxD : ='$(vMaxDatum)'

vMaxDatum : =Date(MAX(Datum))

Why does it say $4 at the bottom? As long as I delete $3 in the parameterized variable vSollzeitmitArbeitsartStartJ (Sum({<$(vIgnore),Datum={“$(vStartJMaxToEndeMStartJMaxDatum($1,$2))”},ArbeitsartNr = {$3}>}SollZeit)) and re-enter it manually. Then everything works again.

The problem reappears after the app is reloded. The calculation no longer works.

Thank you in advance.

BR Richard

[Daniel_Castella · Accepted solution]

Hi @RichardRozgonyi 

If the variable changes every time you reload the app, maybe it is reading it from a config file or other place where that parameter is set as $4.

Other option is that the variable was first stored with the $4 and changing it manually only works temporarily, but it doesn't store the change inside the app. For this reason, every time it is reloaded the old parameter comes in. Have tried to fully delete the variable and create it again?

Kind Regards

Daniel

[marcus_sommer]

You may try:

vSollzeitmitArbeitsartStartJ : Sum({<$(vIgnore),Datum={"$(=$(vStartJMaxToEndeMStartJMaxDatum($1,$2)))"},ArbeitsartNr = {$3}>}SollZeit)

Beside this I suggest to consider to simplify the logic by not nesting (parametrized) variables because variables have the aim to simplify an approach and not adding an extra complexity.

[RichardRozgonyi]

Hello Daniel,

Yes, you're right. The solution was to delete all the parameterized variables that were affected and recreate them. It was necessary to save them under new names, otherwise they wouldn't have worked. But you pointed me in the right direction.

Br Richard

[RichardRozgonyi]

Hello Marcus,

Thank you for your reply. I need the nesting because the variables are used in many places. Daniel's suggestion pointed me in the right direction, so that was the solution for me.

Thank you and best regards, Richard