Ok so getting the average means dividing the sum by the count. Meaning I have a column with a count of 7 rows of numbers that all add up to the sum of 10. So I divide 7/10 to get 70%. Using a combination of calculated columns and workflows I am able to spit out the average number of a column.
HOWEVER, this one column has a slight twist, and I feel there’s a mathematical formula someone can give me to figure it out, but I can’t get it.
The issue is one of my single rows may represent up to two counts. The way this form was setup is a user can essentially enter two forms’ worth of info into one form. I have to parse out when they’ve entered only one form or two forms’ worth of info and if they’ve entered more than one form, I have to somehow add that to the count total to get an accurate average.
Right now I can create a calculated column to parse out whether there’s one or two forms entered and spit out a number 1 or 2 respectively. However, at that point I don’t know how to adjust the count to get an accurate average. Can anyone help? Thanks so much!
To clarify further, here’s a basic example of how my column turns out:
FORM COLUMN 1 1 1 0 2 1 1 —- Average: 100%
See that my column spits out an average of 100% because it’s dividing 7 by 7. However, the row item that states the number 2 is actually trying to say that’s two rows of info, so I need it to calculate the average as if the column looked like his:
FORM COLUMN ACCURATE 1 1 1 0 1 (split from the 2 items) 1 (split from the 2 items) 1 1 —- Accurate average: 87.5%
See how when you account the 2 as a COUNT of 2, you get the accurate average because it’s 8 items, but 7 are accurate so we get 87.5% accuracy.
Let me know if I need more clarification but hopefully someone can help me figure this out. Thanks so much!