asked on # Calculate percentages

Ok I thought I would know how to compute this but I'm having a brain freeze right now.

I need to calculate the % of 2 percentages. I have a value of 61% which is the percent of sales QTD v sales target. Then I have another percentage which shows how many days in the quarter have elapsed so far, which is 78%. So I need to figure out what percent the 61% is of the 78%. Any ideas?

I need to calculate the % of 2 percentages. I have a value of 61% which is the percent of sales QTD v sales target. Then I have another percentage which shows how many days in the quarter have elapsed so far, which is 78%. So I need to figure out what percent the 61% is of the 78%. Any ideas?

Microsoft Excel

Log in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a question
Shouldn't it be higher than that? I would think that 50% of 78% would be 39% so if it's 61% it seems like it should be higher than 47.58%?

Hi,

50% = 39%

+10% = 7.8%

+ 1% = 0.78%

=>

61%= 47.58%

50% = 39%

+10% = 7.8%

+ 1% = 0.78%

=>

61%= 47.58%

ok I'm confused. Let's say my percent is 39% instead of 61% and it's still 78% through the quarter. What would be the answer to that? Wouldn't it be 50% since that's half of 78%?

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

James Murphy

Log in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a question
it may be easier to explain by looking at true values rather than percentages.

Using your example, lets say your quarter target is $1000 and you currently have $610 which is 61% of the target by doing (610/1000)*100

As you are 78% of the way through the quarter you should have $780. The $610 as a percentage of $780 is (610/780)*100 = 78.21%, as per previous solution but this doesn't really show anything other than you are behind schedule. In Earned Value Management (EVM) this would be shown as an indice by deducting the result from 1

1-(610/780) = 0.22

0 to 1 represents behind schedule

Less than 0 represents ahead of schedule

In order to get back on target performance has to increase by 177% ie (390/220)*100 390 being balance of target remaining and 220 being the expected traget remaining.

Thanks

Rob H

Using your example, lets say your quarter target is $1000 and you currently have $610 which is 61% of the target by doing (610/1000)*100

As you are 78% of the way through the quarter you should have $780. The $610 as a percentage of $780 is (610/780)*100 = 78.21%, as per previous solution but this doesn't really show anything other than you are behind schedule. In Earned Value Management (EVM) this would be shown as an indice by deducting the result from 1

1-(610/780) = 0.22

0 to 1 represents behind schedule

Less than 0 represents ahead of schedule

In order to get back on target performance has to increase by 177% ie (390/220)*100 390 being balance of target remaining and 220 being the expected traget remaining.

Thanks

Rob H

That makes total sense. Thank you for explaining that. I think I will use that as well to show how much they are ahead or behind and what they need to generate to get back on track, etc. Thank you again for explaining that.