Calculate Average from two columns in a Metrix

[FMeuldijk]

Hi, I want to calculate an average from 2 columns:

Column 1: Number of Documents

Column 2: Number of Days

I manually created an additional column in my data which calculates the correct average for each line item.

But when I want to display this column in the Matrix (average) the values seems to be incorrect.

See attached example:

Any idea how to solve this?

[judspud · Accepted solution]

Hi @FMeuldijk 

Try creating a measure that is the sum of documents created divided by the sum of days.

When added to a matrix this will calculate it at a row level context but also correctly at the totals

Hope this helps

Thanks,

George