How to apply IF condition and operation minus ("-") to compare data on one table

• phina_el

  SSC-Addicted

  Points: 408

  More actions

  May 26, 2010 at 9:02 pm

  #225074

  Hi All

  I have the view data like this:

  Model Date upload May June

  AAA 2010-05-21 4500 3500

  AAA 2010-05-14 1500 2500

  BBB 2010-05-21 5500 0

  BBB 2010-05-14 0 6500

  and i need output report like:

  Model Date upload May June

  AAA 2010-05-21 4500 3500

  AAA 2010-05-14 1500 2500

  DiffAAA 3000 1000

  BBB 2010-05-21 5500 0

  BBB 2010-05-14 0 6500

  DiffBBB -5500 6500

  How to apply IF condition and operation minus ("-") to compare data on one table?

  Please suggest with your experience which is suitable for me.

  Thank You....

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  May 27, 2010 at 10:51 am

  #1173455

  Hi,

  Will the data will be like this always ,how you provided , I mean only two record for one model? If so do like this

  1) Insert a table group on Model

  2) Insert Group footer

  3) In the expression for the columns of May you can give as

  =First(Fields!May.Value)-Last(Fields!May.Value)

  and for June

  =First(Fields!June.Value)-Last(Fields!June.Value)

  Thanks & Regards,
  MC

• phina_el

  SSC-Addicted

  Points: 408

  More actions

  June 3, 2010 at 8:31 pm

  #1176285

  Hi MC...

  This is a good workaround to apply. And the best thing is that it works fine!!! 🙂

  Thanks a lot, It was very help full!