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
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
Yes i tried like this it display the wrong answer
Hi Can You Try the Below?
=SUM(Fields!SalesUnitPrice.Value) / Count(Fields!SalesUnitPrice.Value)
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
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156