Home

Calculating Percentage of a Changing Total

%3CLINGO-SUB%20id%3D%22lingo-sub-440166%22%20slang%3D%22en-US%22%3ECalculating%20Percentage%20of%20a%20Changing%20Total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-440166%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EThis%20is%20my%20first%20post.%20I%20made%20a%20Manager%20Nightly%20Scorecard%20where%20each%20night%20a%20manager%20gets%20rated%20in%2010%20areas%20with%20a%200%2C%201%20or%202.%20I%20have%20a%20SUM%20total%20at%20the%20end%20showing%20the%20total%20of%20those%20numbers%20per%20category%2C%20but%20I%20would%20ALSO%20like%20to%20have%20a%20percentage%20of%20TOTAL%20calculating%20daily.%20The%20problem%20is%20that%20each%20day%20the%20possible%20total%20increases%20by%202%20from%20the%20day%20before.%20I'd%20like%20to%20show%20the%20percentage%20just%20after%20the%20Total%20Score%20on%20the%20right.%20How%20do%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-440166%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-446357%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20Percentage%20of%20a%20Changing%20Total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-446357%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319606%22%20target%3D%22_blank%22%3E%40eric2501%3C%2FA%3E%26nbsp%3B%2C%20what%20is%20the%20percentage%20here%2C%20per%20cent%20of%20Total%20from%20what%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-467439%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20Percentage%20of%20a%20Changing%20Total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-467439%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20response!%20Each%20day%20the%20Possible%20highest%20score%20for%20the%20month%20increases%20by%202%20points.%20The%20first%20day%20of%20the%20month%20someone%20could%20be%20scored%20a%200%2C%201%20or%202.%20If%20that%20employee%20receives%20a%20score%20of%200%20out%20of%20a%20possible%202%2C%20the%20percentage%20of%20Total%20at%20that%20point%20would%20be%200%25.%20If%20they%20received%20a%20score%20of%201%20that%20would%20be%20a%2050%25.%20Each%20day%20the%20total%20possible%20changes%20by%20increasing%20another%202%20points.%20If%20after%205%20days%20an%20employee%20receives%20scores%20of%201%2C%202%2C%201%2C%202%2C%200...then%20their%20%22Percent%20of%20Total%22%20would%20be%2060%25%20so%20far%20for%20the%20month%20since%20they%20received%20a%20score%20of%206%20out%20of%20a%20possible%2010%20points.%20I%20already%20have%20a%20simple%20SUM%20formula%20for%20the%20Total.%20Does%20that%20make%20sense%3F%20I%20apologize%20for%20not%20knowing%20the%20proper%20statistical%20language%20to%20ask%20an%20intelligent%20question...I'm%20kind%20of%20shooting%20in%20the%20dark...ha%20ha.%3C%2FP%3E%3C%2FLINGO-BODY%3E
eric2501
New Contributor

Hi!

This is my first post. I made a Manager Nightly Scorecard where each night a manager gets rated in 10 areas with a 0, 1 or 2. I have a SUM total at the end showing the total of those numbers per category, but I would ALSO like to have a percentage of TOTAL calculating daily. The problem is that each day the possible total increases by 2 from the day before. I'd like to show the percentage just after the Total Score on the right. How do I do this?

2 Replies

@eric2501 , what is the percentage here, per cent of Total from what?

@Sergei Baklan 

Thank you for the response! Each day the Possible highest score for the month increases by 2 points. The first day of the month someone could be scored a 0, 1 or 2. If that employee receives a score of 0 out of a possible 2, the percentage of Total at that point would be 0%. If they received a score of 1 that would be a 50%. Each day the total possible changes by increasing another 2 points. If after 5 days an employee receives scores of 1, 2, 1, 2, 0...then their "Percent of Total" would be 60% so far for the month since they received a score of 6 out of a possible 10 points. I already have a simple SUM formula for the Total. Does that make sense? I apologize for not knowing the proper statistical language to ask an intelligent question...I'm kind of shooting in the dark...ha ha.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies