SSRS Arithmetic operator issue

• fawad.majid

  Mr or Mrs. 500

  Points: 551

  More actions

  February 6, 2017 at 9:43 am

  #334791

  Greetings

  I need your help in SSRS Reporting.. i run a report every day which give me current statistics and i need to add another line in there whcih i did by adding another value in chart data by whiich column i need it to Subtract it from...

  now i dont know how can i substract two values from the same data..

  What i want is to substract yesterday value from today value or data is should say..

  i'll give you example..

  i have RECORD_WORKFLOW_STATE column which give me the value of the record which is today's data (its created in chart data)
  I added one more RECORD_WORKFLOW_STATE column which should give me the difference of yesterday & Today data.. 

  can someone help me in that please ..

  Regards

• Thom A

  SSC Guru

  Points: 99009

  More actions

  February 6, 2017 at 9:51 am

  #1926908

  I think you need to handle this in your SQL, NOT SSRS. What version of SSRS and SQL Server are you using? Can you provide a copy of your query?

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk