How can I add a variance column into my SSRS report

• rabentham

  SSC Journeyman

  Points: 83

  More actions

  May 13, 2015 at 6:01 am

  #298145

  Hi

  Below is a picture of my report format. It's the yellow column in trying to calculate which is basically a subtraction between the 7th Column (which is based on the date selected by the user in the parameter) and column 6 which is the day before.

  I can't figure out how to do this. ANy help would be much appreciated. Thanks

  

• cunningham

  SSCarpal Tunnel

  Points: 4595

  More actions

  May 14, 2015 at 9:41 am

  #1797904

  can't see the image but why don't you just write it into the query like

  select

  cola

  ,colb

  ,cola-b "variance"

  from table

  then create the report from that data set?