Set multiple pre-set Values in formula

[Anonymous]

Hello community,

I want to sum the value of "FA.Abfuellzeit" for the current week in the current year.

the variable: vAktuelleKW = week(date(today()));

I started with the expression: =(sum({$<KW={$(=vAktuelleKW)}>} FA.Abfuellzeit)) which already puts out the value for the current week, but for all years possible.

How can I achieve it, that the year is the current one as well?

Thank you for your help in advance.

[Anil_Babu_Samineni · Accepted solution]

You meant to say this?

vMaxYear = Year(Today());

And Expression is this?

=(sum({$<KW={$(=vAktuelleKW)}, Year={$(=vMaxYear)}>} FA.Abfuellzeit))

[Anonymous]

Yes, it works!

Thank you, that was exactly what I was looking for, yet so simple!

I apprechiate that.

Thanks