Hi all,
In my group footer(s) I am displaying averages (using Avg). However, I need these averages to exclude any zero and null values in the detail lines. How do I go about doing that?
Lucien Dol
QicSoluciens
Wellington, New Zealand
(Telerik Reporting Q1 2011 v5.0.11.316)
In my group footer(s) I am displaying averages (using Avg). However, I need these averages to exclude any zero and null values in the detail lines. How do I go about doing that?
Lucien Dol
QicSoluciens
Wellington, New Zealand
(Telerik Reporting Q1 2011 v5.0.11.316)
1 Answer, 1 is accepted
0
Hi Lucien,
Peter
the Telerik team
The Avg(Expression) aggregate by design returns the average of all non-null values from the specified expression. Additionally to avoid the zeros our suggestion is to use an IIF Function in the aggregate's expression:
= Avg(IIf(Fields.Year<>0, Fields.Year, Null))
Peter
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items