Hello, I want to create a monthly billing rate plan based on annual thresholds. Yearly Thresholds 1: 0-500: 3,5% 2. 501-1.000: 3,0% 3: 1.001-3.000: 2,5% 4: 3.001-5.000: 2,0% 5: 5.000- xxx: 1,5% At the moment the monthly usage will be extrapolated to the year and the correspending percentage is set e.g. Month 1: 400*12 = 4.800 = Threshold 4 = 400*2% = 8 Month 2: 100*12 = 1.200 = Threshold 3 = 100*2,5% = 2,5 Month 3: 600*12 = 7.200 = Threshold 5 = 600*1,5% = 9 At year end there is a final settlement with peaks that we would like to smooth over the year. Correct Billing would be: Month 1: 400 = 400*3,5% = 14 Month 2: 100 = 100*3,5% = 3,5 Month 3: 600 = 500*3% + 100*2,5% =17,5 Is that possible? Best, Daniel Best regards, Daniel
... View more
