Assistance Request for Automatic Monthly Field Calculation

[BigBoss]

Hello,
Could you please explain how to automatically calculate a field that updates every month?

For example, I have the following data:

Date: 01/09/2024, form1 = 2000

Date: 01/10/2024, form1 = 2200

Date: 01/11/2024, form1 = 2300


Total = ?

How can I calculate the total, knowing that each month a new record is added, with only the date and amount changing?

[Vadym]

Hi BigBoss,

Please provide more details about the logic you're trying to achieve, fields type, screenshot of entity detail view, etc., so we can find the best solution for you.