if {vwProdAnalysis.Procedure_Code} = "J2505" then "2665.04"
else if {vwProdAnalysis.Procedure_Code} = "J9035" then "56.36"
else if {vwProdAnalysis.Procedure_Code} = "J9355" then "68.81"
else if {vwProdAnalysis.Procedure_Code} = "J9171" then "4.28"
else if {vwProdAnalysis.Procedure_Code} = "J9310" then "594.37"
else if {vwProdAnalysis.Procedure_Code} = "J9263" then "4.03"
else if {vwProdAnalysis.Procedure_Code} = "J2469" then "15.23"
 and so on...

 

The formula works great, but I need to multiply the value returned from that formula against another value in the report (units). The formula I tried initially is:

 

Sum ({vwProdAnalysis.Units}, {@Location}) * {@CostUnit}

 

but it requires a number, etc.

 

Any ideas?

 

Thanks

 

Jeff