There are two dates fields- 'close date' and 'delivery date'. Also, there are 12 number fields Sales April, Sales May likewise in the Opportunity object. I want 'Final Amount' should be equally divided and auto-populate between Sales April, Sales May etc on the basis of difference between close date and delivery date month with one month after close date month
Ex-: If close date is 1/May/2023, Delivery date is 12/Aug/2023, Final Amount is 3000, difference between close date and delivery date months is 4, then Final Amount should be equally divided as follows:
Sales June:1000, Sales July : 1000, Sales August: 1000
Please suggest the way how we can implement this using flow/trigger.

There are two dates fields- 'close date' and 'delivery date'. Also, there are 12 number fields Sales April, Sales May likewise in the Opportunity object. I want 'Final Amount' should be equally divided and auto-populate between Sales April, Sales May etc on the basis of difference between close date and delivery date month with one month after close date month
Ex-: If close date is 1/May/2023, Delivery date is 12/Aug/2023, Final Amount is 3000, difference between close date and delivery date months is 4, then Final Amount should be equally divided as follows:
Sales June:1000, Sales July : 1000, Sales August: 1000
Please suggest the way how we can implement this using flow/trigger.