Need Percentage Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2405250%22%20slang%3D%22en-US%22%3ENeed%20Percentage%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2405250%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20in%20creating%20a%20formula.%20I%20thought%20I%20was%20good%20at%20this%20stuff%20but%20I%20guess%20not%2C%20because%20I%20can't%20figure%20it%20out.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20given%20a%20report%20in%20PDF%20format%2C%20to%20create.%20I%20do%20not%20have%20access%20to%20the%20original%20Excel%2C%20to%20copy%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20what%20I%20need%20help%20with%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMonth%20Forecast%20-%2010%3C%2FP%3E%3CP%3EMTD%20Delivered%20Units%20%3D%207.%3C%2FP%3E%3CP%3ESelling%20Days%20-%2026%3C%2FP%3E%3CP%3ESelling%20Days%20Completed%20-%2022%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20the%20tracking%20%25%2C%20how%20much%20I%20need%20to%20go%20to%20hit%20forecast.%20In%20the%20example%20I%20sent%2C%20the%20tracking%20percentage%20came%20to%2083%25.%20I%20know%20I%20should%20be%20pacing%208%20units%20at%20this%20time%2C%20not%207%2C%20so%20what%20percentage%20of%20my%20goal%20have%20I%20hit%20in%2022%20days%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2405250%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2405503%22%20slang%3D%22de-DE%22%3ESubject%3A%20Need%20Percentage%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2405503%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1068595%22%20target%3D%22_blank%22%3E%40baronjosefr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20a%20small%20example%20...%20as%20far%20as%20I%20can%20understand%20what%20exactly%20you%20are%20trying%20to%20accomplish.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAttached%20is%20the%20file%20where%20you%20can%20see%20and%20use%20the%20simple%20formulas.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHope%20to%20have%20helped%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENikolino%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EI%20know%20that%20I%20don't%20know%20(Socrates)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2413492%22%20slang%3D%22en-US%22%3EBetreff%3A%20Need%20Percentage%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2413492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20calculations%20are%20fine%2C%20individually%2C%20thank%20you.%20I%20just%20can't%20seem%20to%20put%20it%20in%20to%20one%20string.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need help in creating a formula. I thought I was good at this stuff but I guess not, because I can't figure it out. 

 

I was given a report in PDF format, to create. I do not have access to the original Excel, to copy it. 

 

Here is what I need help with:

 

Month Forecast - 10

MTD Delivered Units = 7.

Selling Days - 26

Selling Days Completed - 22

 

I need the tracking %, how much I need to go to hit forecast. In the example I sent, the tracking percentage came to 83%. I know I should be pacing 8 units at this time, not 7, so what percentage of my goal have I hit in 22 days?

5 Replies

@baronjosefr 

Here is a small example ... as far as I can understand what exactly you are trying to accomplish.

Attached is the file where you can see and use the simple formulas.

 

Hope to have helped you.

 

Nikolino

I know that I don't know (Socrates)

@NikolinoDE 

 

The calculations are fine, individually, thank you. I just can't seem to put it in to one string. 

 

 

Was und Wie genau möchten Sie es haben?
I finally got that one together. You were 100% the reason I was able to. Thanks. Now, I have to figure out how to project a forecast, and how much I am pacing to reach a goal.

@baronjosefr 

Attached two files that might help you in your project.

 

Many different templates that you can download for free from Microsoft and further develop if it suits you.

Forecast Templates

 

 

Thank you for your patience and time.

 

Wish you a nice day / night with lots of health, joy and love.

 

Nikolino

I know I don't know anything (Socrates)

 

*If you find this helpful, please mark it as "Best Answer" or give a “Like”, it will be beneficial to more Community members reading here.