CODEWITHSUNDEEP
sqlreporting-servicesssrs-2008
Neo
Neo

Reputation: 16219

How can I write expression to take an subtraction of two fields in ssrs?

I'm working on SSRS report.

There are two main fields CurrentMV and PreviousMV.

field CurrentMV having expression =Sum(Fields!CurrentMV.Value)

field PreviousMV having expression =Previous(Sum(Fields!CurrentMV.Value))

I'm having another field on report MTM which is nothing but difference between

CurrentMV- PreviousMV How can I write expression for MTM as there is already expression used in CurrentMV and PreviousMV

please help me.

Upvotes: 1

Views: 7310

Answers (2)

Ciarán
Ciarán

Reputation: 3057

=Sum(Fields!CurrentMV.Value)-Previous(Sum(Fields!CurrentMV.Value)) ? or am I missing something obvious?

Upvotes: 0

paul
paul

Reputation: 22001

=Sum(Fields!CurrentMV.Value) - Previous(Sum(Fields!CurrentMV.Value))?

Upvotes: 3

Related Questions