Forum Discussion
Anonymous
6 years agoNot applicable
Average function giving different result per row
Hi,
I'm trying to get an average from a column but is giving a different value every row.
I'm unsure how to find the average for the entire column.
The data source is a salesforce report I created with some mock cases.
I've created a new column to calculate the average:
Average IRT= AVERAGE('Closed cases'[Initial response business hours])
Output:
Anyone have an idea how to get one value for the entire column?
Thanks!
- Anonymous6 years ago
I've found the solution.
The problem was with how the report was being generated not with the formula.
6 Replies
- mussaendaCommunity ChampionHi Anonymous ,You may want to try this:
Average IRT= CALCULATE(AVERAGE('Closed cases'[Initial response business hours]), ALL('Closed cases'))