Hello ))
SO i need to put a formula in quarterly targets fields which will calculate the amount that is needed for the target to be achieved.
Target amount is determined by percentages in each quarter which is based on business levels.
If Q1 ACT is higher than what was supposed to be achieved as 25% of the target than the target in Q2 will be lower.
If Q1 ACT is lower than 25% of the target then the remaining amount should be carried over and added on top of the Q2 target.
Target yet to be reached should be a negative number and if overachieved the number will be in positive (and green if possible).
I tried with simple add/subtract formulas and did not manage due to the number depending on actuals (i didnt know the formula)
Thanks a bunch!!!
Bookmarks