
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 27, 2021 08:32 PM
Hi! :wave:
I am having some difficulty with creating a formula in my database. I have one table - ‘Feedback’ - where each row is a bit of customer feedback, and each bit of feedback has a column for ‘Insight’ (i.e. what type of problem it is) and another column for ‘CSAT score’ (ranging from 1-5). I have another table - ‘Insights’ - which lists all the insights from the feedback table in the first column (these are linked).
What I want to do is calculate the average CSAT score for each insight. I have managed to create a new column in the insights table entitled ‘CSAT Score (from Feedback)’ which looks up the CSAT scores from the other table and presents them for each insight, separated by a comma.
What I then want to do is create another column which averages these scores. However, when I used the formula average({CSAT Score (from Feedback)}
, I get the error message shown below.
Do you know how I can fix this?? The CSAT scores in the Feedback table are formatted as numbers, so I thought I could get this to work.
Thanks!!!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 27, 2021 08:38 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 27, 2021 08:38 PM
Try AVERAGE({CSAT Score (from Feedback)})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 27, 2021 08:43 PM
You are a genius! Thank you!!! Of course it was missing a ). :woman_facepalming:
