How to create an average line

Anonymous — Thu, 18 May 2017 13:01:05 GMT

Hi,

I have a combo chart, I will like to add a line for the average of records.

This is the formula created to displays the information:

SUM ({$<[Closure Code] -= {'Duplicate Request', 'Invalid DM Request'}>}[DM Case Count])/SUM ([Open Count])

How can I create an average of that formula?

If I add the avg function at the beginning I got an error on the expression.

Please advise.

Re: How to create an average line

Anil_Babu_Samineni — Thu, 18 May 2017 13:24:38 GMT

How about this?

RangeAvg(SUM ({$<[Closure Code] -= {'Duplicate Request', 'Invalid DM Request'}>}[DM Case Count])/SUM ([Open Count]),0)

RangeAvg(SUM ({$<[Closure Code] -= {'Duplicate Request', 'Invalid DM Request'}>}[DM Case Count])/SUM ([Open Count]),Avg(1))