Filter

[stoha001]

Hi. 

How to filter this to include both "Income" and "Expenses" but for "Expenses" only want to include "Parking expenses" and "Travel expenses"

[Prometheus]

@stoha001 Use a Filter tool with this expression: [Wage Type] in ('Income', 'Expenses') and [Wage Type Desc] in ('Parking expenses', 'Travel expenses')

 

[DanielG]

[Wage Type= "Income" or ([Wage Type] = "Expenses" and [Wage Type Description] in ("Parking expenses", "Travel expenses"))

@stoha001 

Put that statement in your custom filter and you should get what you want