COMPOSITE QUERY
I am trying to create an expression in a composite query. The expression will be a new field within the query.
the following CASE statement results in an execution error.
case when #{PRICE_CHANGE.A.CHNG_NBR_VALUE:11} IS NOT NULL then #{PRICE_CHANGE.A_CHNG_NBR_VALUE} * #{ORIG_QTY.A.CHNG_NBR_VALUE:10}
WHEN #{QTY_CHANGE.A.CHNG_NBR_VALUE:12} IS NOT NULL then #{QTY_CHANGE.A.CHNG_NBR_VALUE} *#{ORIG_PRICE.A.CHNG_NBR_VALUE:9} else 0 END
Sample data:
I want to be able to have the new column be: original qty = 5 X price change = 50. result: 250
Any assistance is greatly appreciated.