Correct Expression or Method to subtract same field value in single group across column group members

• rsiem

  SSC-Addicted

  Points: 479

  More actions

  July 28, 2014 at 8:42 am

  #288217

  I have a "simple" matrix report using SSRS 2012 that shows a bid category with various dollar fields associated with a Ship To address. See attached Jamie Allocation Report Design Matrix image file.

  We have the matrix using a column group called Source SP (source stockpile = warehouse).

  The Source Stockpile is also a parameter in which the user can select multiple stockpiles using a checklist. This parameter allows multiple values.

  Generally the user will be selecting between 2 to 4 stockpiles for this report.

  Each stockpile has a column called TDC Less SPC.

  Problem is trying to subtract the dollar value for the TDC Less SPC field within the single Source Stockpile column group for each of the stockpiles selected (i.e. Stockpile A.TDC Less SPC - Stockpile B.TDC Less SPC).

  See attached Jamie ReportField Output image file. From the image file:

  Would like to subtract the $ 36.20 TDC value for Stockpile DuBois from the $ 37.36 TDC value for Stockpile Pleasant Gap and display that difference in a new column called "Difference".

  Question 1: How to subtract a field value within a column group for each of the group members (i.e. Value 1 for Stockpile A - Value 1 for Stockpile B)?

  Question 2: How do I eliminate the blank report output lines within the group so that each bid appears as a single report line for each stockpile?