I wrote the follow custom expresssion:
case( ( [Invoice Type] = "ClosedInvoice" OR ( [Invoice Type] = "SettledInvoice" AND [Invoice Total Premium Local] < 0 ) ), "Yes", "No")
But when I save Metabase seems to strip the expression of its internal ()'s making the Logic statement incorrect. Also, we have seen it cause the Metabase UI to just spin, which blocks me from now using that Question.
Any help on how I can incorporate a CASE with an OR statement?