How do create a filter with multiple parameters

jessreidad — Fri, 01 Apr 2022 15:33:47 GMT

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)

Re: How do create a filter with multiple parameters

JoeM — Fri, 01 Apr 2022 17:01:36 GMT

@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.

topic How do create a filter with multiple parameters in Dashboards & Analytics Discussions

How do create a filter with multiple parameters

Re: How do create a filter with multiple parameters