How to display average in rdlc report

(0) Share

Report

Posted on by yoheswaran

225

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

All responses (4)

Answers (0)

yoheswaran 225 on at

Like (0)

Report

RE: How to display average in rdlc report

Yes i tried like this it display the wrong answer
Suggested answer

Pushparaj on at

Like (0)

Report

RE: How to display average in rdlc report

Hi Can You Try the Below?

=SUM(Fields!SalesUnitPrice.Value) / Count(Fields!SalesUnitPrice.Value)
yoheswaran 225 on at

Like (0)

Report

RE: How to display average in rdlc report

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
Suggested answer

Steven Renders 5,051 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to display average in rdlc report

Avg(Fields!SalesUnitPrice.Value)

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

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