How do create a filter with multiple parameters

[jessreidad]

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.

case((BizHospital_Internal.Return_Item.order_credit_source = '3',BizHospital_Internal.Return_Item.order_credit_batch_type = 'U')),BizHospital_Internal.Return_Item.rtn_item_ext_value,0)

[JoeM]

@jessreidad  - Could you try this?

case(
    and(
     BizHospital_Internal.Return_Item.order_credit_source = '3', 
     BizHospital_Internal.Return_Item.order_credit_batch_type = 'U'
    ), 
BizHospital_Internal.Return_Item.rtn_item_ext_value, 0)

 I added a quick 'and' statement here.