Trying to figure out percentages

Hello.

This might be a tricky one as I'm still trying to figure it out. I'm building a tracker to track new employees' training progress. Each week has a different amount of segments needing to be completed. So there is a column for Day 1 training, each week (4 weeks), as well as a column for the total amount of segments. My issue is with trying to get the last column to show a total percent completion based on how many segments are done in each week. So if only 5 segments are complete in week 3, no segments in Week 4, but all segments from Day 1, Week 1 and Week 2 are complete, the percentage is accurate based on how many out of 46 total segments are complete. Sounds basic enough in my head, but I'm still missing something. I started this from a template I found online which was tracking something similar and uses an IFERROR formula to figure out the percentage.

I can't include a screenshot as I haven't posted enough but I'm hoping someone can help me out with this. I should also add that this is in a chart.

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

It sounds as if you would like the % of Training Completed column populated using:

Formula:

=IFERROR(SUM(Tracker[@[Day 1]:[Week 4]])/46,0)

If that does not work, then please tell us the expected results for cells J4:J5 and how they were manually calculated so that we can try to replicate those results using a formula/code.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.