Script question with active selection

[Aurél]

Hello,

I have 2 fields for selection : Year and Period.
For example, if I select April 2022, I'd like to sum the amount of all years up to April 2022.
How can I just do that, please?

Thank you.

[ogster1974]

sum({<Year={"=Year<=Max(Year)"}>} Amount)

[Aurél]

No.., It's display the sum over 2022 and not min(year) to 2022

[Aurél]

If I use
SUM({<Year= {"<= $(=max(Year))"}>} Amount)

It's OK but I display all 2022 and not until my selected period (April 2022)

[ogster1974]

Assuming you have a MonthYear Field in your master calendar

SUM({<MonthYear= {"<= $(=max(MonthYear))"}>} Amount)

[Aurél]

Yes, I have this field... I tried but it doesn’t work because I select the field Year... and if I select 2022 it'ill take me MonthYear  for 2022... : 202201...202204 but not 2021... etc

[ogster1974 · Accepted solution]

try this to ignore the Year filter you've set.

SUM({<Year=, MonthYear= {"<= $(=max(MonthYear))"}>} Amount)

[Aurél]

Perfect 😊.

Thank you very much !

[ogster1974]

you're welcome got there in the end 🙂