I have a table with the 12 months of the year (12 records).
Inside I have a numeric field 'field A'.
Is it possible in each month to have a 'field B' field with the progressive sum of the 'field A' field so that if I enter the February record I only see the progressive sum of January + February?
thanks in advance
I honestly cannot understand the application of your code.
I try to repeat my situation.
I have a "Months" table which contains 12 records.
In each record I have:
- Text field with the name of the 'Month'
- Numeric field with the number of the month 'Month n °'
- Numeric field with a 'Budget €'
I should create a formula field that contains the running total of the 'Budget €' field