Totaling columns.

Question

How can I add two columns in ssrs? When I do ssrs expression sum(Field!Results.Value).
I get incorrect total.

Answer 1

Hi Zoe,

Thanks for your help. I figured out what I was doing wrong and the two numbers weren't adding up correctly. The issue was with my query. thanks again

Answer 2

Hi @Kimmie ,

You may add a single textbox and use sum(Field!Results.Value) for a test.

You may also use add total and then use sum(Field!Results.Value).

Here is may own test:

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/report-builder-functions-sum-function?view=sql-server-ver15

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-total-to-a-group-or-tablix-data-region-report-builder-and-ssrs?view=sql-server-ver15#:~:text=is%20automatically%20added.-,To%20add%20totals%20for%20a%20row%20group,then%20click%20Before%20or%20After.

If I misunderstand your meaning, I'd like to suggest that you may share the design sample for us to do more analysis.
Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Answer 3

Hi Zoe,
I tried adding a test and doing sum(Field!Result.Value) and RunningValue(Field!Results.Value,SUM,”CTL”), neither worked. Add total is greyed out, but I can select it from the group panel but that does not work either.