Display the difference between 2 columns where multiple columns associated from dynamic matrix in ssrs 2008 r2

Question

Post reply

Display the difference between 2 columns where multiple columns associated from dynamic matrix in ssrs 2008 r2

sunitha 20026

Mr or Mrs. 500

Points: 509
More actions
April 25, 2017 at 8:37 am

#342609

I have to show the data in the report just like above .. i need to get the difference of Medicaid 2017 value and Medicaid 2016 in Med diffrence
commercial 2017 value and commercial 2016 in commercial difference column... note that 2016 & 2017 are dynamic values as year changes these will change..any pointers would really help?
Appreciate your response.
Thank you!!!!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

David Burrows SSC Guru Points: 65138 More actions · Answer 1

Are there only two years shown?

Far away is close at hand in the images of elsewhere.
Anon.

sunitha 20026 Mr or Mrs. 500 Points: 509 More actions · Answer 2

David Burrows - Tuesday, April 25, 2017 9:36 AM
Are there only two years shown?

YES, it is always for current year and previous year.. any insight would really help

Thanks in advance!

David Burrows SSC Guru Points: 65138 More actions · Answer 3

Adapt the following to suit your needs

Sum(IIf(Fields!Payer_Type.Value="Medicaid",Fields!XXXXXXXX.Value,0) * IIf(Fields!SMN_Year.Value = Min(Fields!SMN_Year.Value),-1,1))

Far away is close at hand in the images of elsewhere.
Anon.

sunitha 20026 Mr or Mrs. 500 Points: 509 More actions · Answer 4

David Burrows - Thursday, April 27, 2017 10:48 AM
Adapt the following to suit your needs
Sum(IIf(Fields!Payer_Type.Value="Medicaid",Fields!XXXXXXXX.Value,0) * IIf(Fields!SMN_Year.Value = Min(Fields!SMN_Year.Value),-1,1))

This indeed worked.. Thank you so much
Im fairly new to the ssrs ..could you provide some insight as to I how can improve knowledge

doug.brown SSCertifiable Points: 5607 More actions · Answer 5

sunitha 20026 - Thursday, April 27, 2017 11:27 AM
This indeed worked.. Thanks you so much
Im fairly new to the ssrs ..could you provide some insight as to I how can improve knowledge

The SSRS Stairway on this site is a good starter.