I am trying to create a table for our sales employees rolling bonus program. I have the main bones built, but I am struggling in one area.
I need a way to add values in a compound manner.
- January they reach bonus and earn $500
- February they reach the bonus. They would earn $500 from January + their February bonus (Example $500 + $500)
- March they reach the bonus. They would earn $500 from January + February bonus + March bonus
I need to use the rolling values of these for their commission statements.
Does anyone have any suggestions for a formula?
Thank you kindly