How to create an average line

[Anonymous]

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.

[Anil_Babu_Samineni · Accepted solution]

How about this?

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

Or

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