Search code examples
reporting-servicesreport

How to get the total right result in my report for entered calls?

I have report with entered calls.I want to get the total sum of my column %Weekdays. For example i will show you my values and the expected result: The expected result is 100,7% enter image description here

https://i.sstatic.net/8jKum.jpg

This is my code for %weekdays ( average values ) , but i want total values from all rows:

 =avg(IIF(Weekday(Fields!DATE_YYYYMMDD.Value,2)<6,CDBL(Fields!N_ENTERED.Value),Nothing))/
iif(Sum(IIF(Weekday(Fields!DATE_YYYYMMDD.Value,2)<6, CDBL(Fields!N_ENTERED.Value), Nothing),"PRESENTATION_NAME")=0,1   
    (Sum(IIF(Weekday(Fields!DATE_YYYYMMDD.Value,2)<6, CDBL(Fields!N_ENTERED.Value), Nothing),"PRESENTATION_NAME")/
iif(code.getWeekDaysCount(Parameters!From_date.Value,Parameters!To_date.Value)=0,1,code.getWeekDaysCount(Parameters!From_date.Value, Parameters!To_date.Value))))
Solution

  • If you just want to sum the "% weekdays" column, assuming it's called myWeekdaysCol then you can just do 

    =SUM(ReportItems!myWeekdaysCol.Value)

    The will simply sum the final result without having to create a long, hard to read expression.