How to calculated the interest with following formula cloud ppm opening
We have requirement for interest calculation for the expenditure incurred every month with below formula
"opening 100% cost + average (Current month cost / 2) for the current month addition"
Attaching the schedule created for reference.
Any help will be highly helpful