Hi,
I have a year filter at the top of the sheet (attached screenshot). I want to created a calculated field which is connected to that filter, so when I select a year in the filter, the year used in the calculation will also change.
Here’s the calculated field formula:
(( sumIf ( {Estimated Annual Loss}, Year = 2020 OR Year = “FILTERED YEAR”))/2)*(“FILTERED YEAR” - 2025)
where it says FILTERED YEAR should changed based on the filter. Is this possible?
Thank you in advance for your help!
Hi @yeeman,
You can utilize a parameter value in a calculated field by adding $ in front of it; so if your parameter is called FILTERED YEAR, it would look something like ${FILTERED YEAR}.
Let me know if this helps or if you have any additional questions
Hello @yeeman
Following up on @Brett 's solution above, you will need to turn your filter into a parameter control filter.
Then you can use that parameter in your calculated field.
how to check if user is selected something from the filter?
I would like to reach a goal that:
if value selected, then calculate something, if not then a default calculation.
