I have produced a report in report builder. During the month the report runs ok, however when
the report crosses into a new month e.g. January to February, it seems to split on the number of referrals whereas it should be a total number.
Within my SQL code it shows the split with the Year-month.
See example attached.
In report builder template my number of breaches is a summed and so is the reason for breach.
I have tried to sum my number of referrals but it is giving me 17 as the top line and then 184 as the bottom.
Are there any expressions I can use to give me the correct sum for both rows which would be 63