I am trying to add 2 fields together with different filters. My first parameter is the one below.
I cannot seem to create a statement in which if
BizHospital_Internal.Return_Item.order_credit_source = '3', and
izHospital_Internal.Return_Item.order_credit_batch_type = 'U are true, then BizHospital_Internal.Return_Item.rtn_item_ext_value else 0
I tried the case and if statements and I cannot get it to work.. Any help would be greatly appreciated.