SQL Server 2008 SSIS using percentages

• mike.hinsley

  Grasshopper

  Points: 10

  More actions

  April 6, 2011 at 4:14 pm

  #235292

  Hi,

  I have what is probably a simple question, I'm still a SSIS novice in my opinion and have a need to do a calculation to replace a value with a new one based on a percentage.

  The formula works fine in excel as follows: =100*2.75/(1-32%)

  in SQL the 2.75 would be the value and the 100 would be the quantity but I don't seem to get how to use the 32% part.

  any idea's or pointers would be most greatfull

  Thanks Mike.

• Todd McDermid

  Default port

  Points: 1416

  More actions

  April 6, 2011 at 4:53 pm

  #1308318

  100*2.75/(1-0.32)

  Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
  My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components

• mike.hinsley

  Grasshopper

  Points: 10

  More actions

  April 6, 2011 at 5:14 pm

  #1308323

  Thanks ever so much for your help.

  Regards,

  Mike