Use of If Else

• Jones'e

  Right there with Babe

  Points: 774

  More actions

  March 10, 2006 at 7:57 am

  #91515

  Can you use a IF Else statment in aggregate function such as

  Round(Sum((rcitem.fqtyrecv - If is null dt.qtyfail O else dt.qtyfail end) * rcitem.fucost), 0) as PartCostTot

  Or how might I preform such a test?

  Thanks in advance!

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  March 10, 2006 at 8:39 am

  #626001

  Try the case statement

  rount(SUm((rcitem.fqtrecv- case when dt.qtyfail is null then 0 else dt.qtyfail end) * rcitem.fucost),0)

  Not tested

• Jones'e

  Right there with Babe

  Points: 774

  More actions

  March 10, 2006 at 10:20 am

  #626036

  Worked pefect, Thanks!