How to display average in rdlc report

(0) Share

Report

Posted on by yoheswaran

231

Hi everyone,

Is there any way to display the average in rdlc report for sum field. Eg: Sum(Fields!SalesUnitPrice.Value) for this field expression i need to show average.

Thanks & Regards,

Yoheswaran S

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Steven Renders 5,698 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Avg(Fields!SalesUnitPrice.Value)

learn.microsoft.com/.../expressions-report-builder-and-ssrs

learn.microsoft.com/.../report-builder-functions-aggregate-functions-reference

Was this reply helpful? Yes No
yoheswaran 231 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply but i already use "Sum" expression for the field like Sum(Fields!SalesUnitPrice.Value) - for this cell i need to display average i tried with Avg(Sum(Fields!SalesUnitPrice.Value)) but it's not working

Was this reply helpful? Yes No
Suggested answer

Pushparaj on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Can You Try the Below?

=SUM(Fields!SalesUnitPrice.Value) / Count(Fields!SalesUnitPrice.Value)

Was this reply helpful? Yes No
yoheswaran 231 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes i tried like this it display the wrong answer

Was this reply helpful? Yes No