Dividing two values

[sde821]

Hi all,

I need help to simply build a kpi where the value of a field is divided through another field.

I have this Table:

The value from last date of last year 104,038219 (31.12.2022) should be divided through the value of last day of the year before 108,785167 (31.12.2021). I want the KPI two adjust automatically in 2024 and all other years. How can I do this via variables, in script or front end?

Thanks for helping!

BR

Anna

[srchagas]

create a 2 variables

1 - vMaxActualYear = Max(Your_Year_Field)

1 - vLastActualYear = Max(Your_Year_Field)-1

Then

Sum ( {< Year = , Year = {'$(vMaxActualYear )'}>} Value)

-

Sum ( {< Year = , Year = {'$(vLastActualYear )'}>} Value)

[sde821]

Thank you for your help Srchagas, but it doesn't work. I need the quotient of the two values. 

I have a solution that is working, but I can't use a variable insted of the date. Does anyone know a way to use this formula with a variable?

Only({<[Date]={"31.12.2022"}>} Value)/Only({<DateI={"31.12.2021"}>} Value)

Thanks in advance!