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)

Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

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 (0)

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

Was this reply helpful? Yes No
Suggested answer

Pushparaj on at

Like (0)

Report

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 (0)

Report

Yes i tried like this it display the wrong answer

Was this reply helpful? Yes No