Setting Transaction Amount Based on Average of Past Transaction Amounts
jmine83
Member ✭✭✭
I want to be able to set scheduled transaction amounts based on the average of past transactions amounts over a user specified range of transactions.
Here are some examples of what I mean:
~ Utility bill payments scheduled into the future...
1. Being equal to the average of a specified range of past utility bill payments
Example: The scheduled power bill for April 2020 being equal to the average of all past power bills starting from August 2019.
2. Being equal to the average of a given month based on past year utility bill payments
Example: The scheduled power bill for April 2020 being equal to the average of the power bills paid in April 2019, April 2018, etc. starting from April 2015.
Here are some examples of what I mean:
~ Utility bill payments scheduled into the future...
1. Being equal to the average of a specified range of past utility bill payments
Example: The scheduled power bill for April 2020 being equal to the average of all past power bills starting from August 2019.
2. Being equal to the average of a given month based on past year utility bill payments
Example: The scheduled power bill for April 2020 being equal to the average of the power bills paid in April 2019, April 2018, etc. starting from April 2015.
1
Comments
-
Also consider that if any past transaction amounts are changed within the specified range of transactions being monitored, the upcoming scheduled transaction amounts should automatically update themselves to reflect the change of the past transaction amount.0