topic Dividing two values in App Development

Dividing two values

sde821 — Thu, 23 Nov 2023 12:47:08 GMT

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!

Anna

Re: Dividing two values

srchagas — Mon, 27 Nov 2023 15:31:29 GMT

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)

Re: Dividing two values

sde821 — Wed, 29 Nov 2023 08:26:51 GMT

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!