politicalangel
New Member
Hi,
I need help in creating a formula for the below situation.
Each region( about 30) in the report I am trying to create has different levels so if YTD amounts get to a certain level an additional amount is added..if it moves onto the next level the difference between the previous level and the new amount is calculated and the % awarded to the region.
I need a calculation that I can drag through from month to month for the regions that calculates the bonuses/amount when the levels are met for my accrual.
Please see attachment...
I need help in creating a formula for the below situation.
Each region( about 30) in the report I am trying to create has different levels so if YTD amounts get to a certain level an additional amount is added..if it moves onto the next level the difference between the previous level and the new amount is calculated and the % awarded to the region.
I need a calculation that I can drag through from month to month for the regions that calculates the bonuses/amount when the levels are met for my accrual.
Please see attachment...