Struggling to work out if this can be done.
Scenario: I am charging a client a daily fee using tiered fee rates
First $10,000,000 of value is charged 0.15%
Next $20,000,000 of value is charged at 0.10%
Anything over $30,000,000 is charged at 0.075%
Doing this daily is all well and good, but is there a way I can take an average of the daily values, over say a month, and return the same value as doing individual daily calculations and summing the answers together?
If the value is always above 30 million I have no issue. But what if the value dips below $30M - the arithmetic average of the daily values will no longer return the same value as individual daily calculations.