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!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.