• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 769
  • Last Modified:

Daily Dynamic Target Calculation

Hi ,

I have a Service Level Target for one of my team,. It has a monthly Target.

But I want to calculate the target dynamically based on the past performance.
For an example for the first 5 Days of operation if the team achieved less than the target, then we optimize the daily target in order to catch p the monthly target achievement.

I have attached the sample file, but the target is actually the monthly figure, I am looking forward to get a formula to calculate the dynamic daily targets.
  • 2
1 Solution
The following formula will calculate your dynamic daily target based on past data:

You may copy this formula across.

Note that the formula will predict values greater than 100% when it becomes impossible make your monthly target achievement. If you don't want to display values greater than 100%, then use:
Sample file using the suggested formula
sunil1982Author Commented:
It is a great solution, Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now