please, can anyone here help me to set up properly some calculation fields (formula) in my table?
Let’s say I have a table with student’s names where one of my columns (fields) is a number type, where I put manually the year, when student finished his exam (or let’s say he finished the high scool). I will name this field as “EXAM”.
I would like to create two more fields:
One field - I will call it “CALC”- auto-calculated, where number 25 is subtracted from the “EXAM” field and result is displayed here.
And then another field (I will call it “CALC2”), which will use actual year as an input number (so just now it would be a number 2023, but next year it will be number 2024) and then the number from “CALC” field will be substracted from it and will display the result number.
if I will put the number 2015 in the “EXAM” field, then in “CALC” field I should see the number 1990 and in “CALC2” field I should see the number 33.
One more thing: if the “EXAM” field is empty, then no calculations should be done.