SSRS Calculation of two fields not working
Posted on 2016-11-01
Good morning experts. Still learning SSRS and getting an error on a very simple calculation. I have Two fields in my dataset.
One is called ToFromDays and the other is called TotalTicketsGroup. The ToFromDays has an expression to give the numbers of days between a start date and end date parameter which is =DateDiff("d",Parameters!StartDate.Value,Parameters!EndDate.Value).
The TotalTicketsGroup simply counts the amount of tickets assigned to an assignee and has a very simple expression which is
So when I run my report based on a date parameter of say 10/1/2016 thru 10/31/16 I get a result like this
Total Tickets Group To From Days
So far so good. Now all I want to do (which takes me ten seconds in excel) is to create a new calculated field in my dataset called AverageNumberofTickets the will do just that, give me an average. A simple calculation that divides ToFromDays by TotalTicketsGroup so my result would be
Total Tickets Group To From Days Avg
6 30 0.2
I have tried to create an expression in the calculated field like =Fields!TotalTicketsGroup.Value/Fields!ToFromDays.Value but receive an error when previewing the report. I have tried some other syntax (not listed) as well before becoming frustrated. I know this is simple but don't know what I am missing.