Home Forums Reporting Services Reporting Services 2008 Development Display the difference between 2 columns where multiple columns associated from dynamic matrix in ssrs 2008 r2 RE: Display the difference between 2 columns where multiple columns associated from dynamic matrix in ssrs 2008 r2

  • April 27, 2017 at 11:27 am

    #1940280

    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