Cumulative calculation formula

[system]

is someone able to give me a hint or knowledge on how I will calculate

the below.

for example.

If I have a total Sales of 2.5M

then for <=2M the percentage is 30%
then the 500k left is = to 32%

etcccc.

so its like a cumulative calculation based on sales.

so someone like give me a hit on how to IF formula this?

=if(maximum([sales]) = 2M Then .32 elseif( ???

---

EmilVictor (BOB member since 2019-05-26)

[system]

Here’s a formula based on your example

=If([Sales] > 2000000) Then ((0.3 * 2000000) + (0.32 * ([Sales]-2000000))) Else (0.3 * [Sales])

---

buzz (BOB member since 2005-08-12)

[system]

Welcome to B B!

It does seem the answer above seems absolutely logical and I would reiterate the same

---

BarkyBaloo (BOB member since 2007-07-04)