- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

PQ - need to get average of multiple columns but some of the columns are blank
I have a csv file from a customer survey with 3 survey questions and I would like to get an overall survey score. My formula is basically (column 1 + column 2+column 3)/3. This works perfectly except when one of the survey questions was not answered. When that happens, my score is also blank
What I need is to really only look at the columns that have data. If only one survey question was answered, then have that single score be divided by 1. If only 2 questions where answered, then sum those 2 and divide by 2 etc
Thoughts?
As you can see below, the 2nd and 3rd question was skipped so it's causing the Survey Score to be blank
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Use below formula for average to handle nulls
= List.Average({[Agent Experience],[First Call Resolution],[Overall Satisfaction]})
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Use below formula for average to handle nulls
= List.Average({[Agent Experience],[First Call Resolution],[Overall Satisfaction]})

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-15-2024 01:07 PM | |||
08-29-2024 12:44 AM | |||
09-19-2024 07:52 AM | |||
08-02-2024 06:29 PM | |||
03-26-2024 11:00 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |