I am trying to filter out Expense Accounts (2000 - 2999) and only include assets which are depreciating using Asset nominal accounts (6000-6999) and null nominal accounts (ones where assets are selected to do not depreciate).
When I use a Case statement (attached), the formula will not pick up that the value (the nominal) is null and therefore the account remains blank. This means when I am trying to filter to exclude expense accounts, it is also hiding the null accounts as there isn't a value.
If I use the suggestion to go into column properties > data format and change the blank nominal accounts to 0, when I try and filter to not include expense accounts (NOT BETWEEN 2000 and 2999), it hides all null (0) account values too.
Has anyone faced this issue before:
1) How do I get the query to understand that there are null values so I can populate null values with a 0?
2) How do I filter out the expense accounts but keep null values of the 'do not depreciate' accounts showing and not hidden when filtering?
One option would be to use a UNION and have one with a 2000-2999 filter and the second with a NULL filter.