Hello everyone,

first happy new year to all community members! Could you please help me with the script how I can define a formula field in a form. This form is for collecting data from general ledger. Data are uploaded (imported) regularly.

I want to calculate some KPI-s. If you can help me with an example, hopefully I can do the others.

I have a field for the general ledger account number, the field name is "fkv"

I have a field for the of the account >>> "fkv_name"

And I have  fields for collecting amounts that are booked in a calendar year >>> amount2020, amount2021 etc.

Let's say I'd like to calculate the difference between the 911 and 814 ledger account in 2020.

Can you help with the script, please?!