How to use Subtraction in SSRS report?

(0) Share

Report

Posted on by Sathish Sivakumar

3,732

Hi,

I have been working on SSRS reports. I have 2 totals in child group. Now I have to create a Balance from the parent group. That is Child 1 - Child 2, this is the scenario. How to achieve this?

If anyone knows please update me with a screenshot?

For example:

Child group 1: 100.00

200.00

Total 1: 300.00

Child group 2: 50.00

100.00

Total 2: 150.00

Balance: 150.00 (Total 1 - total 2)

This highlighted 150.00 I have to achieve it in SSRS report.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

have you tried by adding one more footer row by right click and adding below expression

Sum(Fields!FieldName.Value)

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report

Hi Sohaib,

I have tried this way. The way you suggested is doing Addition. My scenario is to Subtract.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

=Sum(Fields!Field1.Value)-Sum(Fields!Field2.Value)

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

interesting. allow me to reproduce scenario and get back to you with my verdict

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Since you are applying grouping on same field so you cannot use only sum subtract as you have grouped name field already.

considering you are having limited number of groups only, I have reproduced your scenario as shown below

you can use expression as following

=Sum(IIF(Fields!ChildName.Value="ABC",Fields!AnyNumber.Value,Nothing))-Sum(IIF(Fields!ChildName.Value="XYZ",Fields!AnyNumber.Value,Nothing))

.

.

Note that you have same field name in both sum() and you are segregating the two sum expression by specifying Field Group expression

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

allow to add one thing more that in above expression provided by me, Fields!ChildName means field name of column based on what you are grouping your data. such as in my example ABC and XYZ are being saved in a column of table, where column or field name is ChildName.

Fields!AnyNumber; AnyNumber is another column name which is saving numbers. here goes my table schema

Was this reply helpful? Yes No