User Profile
ist_eco
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Filter function returning a "0" (Zero) when the source cell is blank or null
I faced the same problem a few weeks ago. Since I could not find a permanent solution, I used the following basic formula as a workaround. =IF(SORT((FILTER(CHOOSE({1\2\3\4\5\6};Transactions!Provider;Transactions!Expense_Center; Transactions!Expense_Sub_Center;Transactions!Account;Transactions!Due_Date;Transactions!Budgeted_Amount);(Transactions!Provider<>"")*(Transactions!Expense_Center<>"")*(Transactions!Category="Expense")*(Transactions!Budgeted_Amount<>"");""));{1\2\3\4\5\6})=0;"";SORT((FILTER(CHOOSE({1\2\3\4\5\6};Transactions!Provider;Transactions!Expense_Center; Transactions!Expense_Sub_Center;Transactions!Account;Transactions!Due_Date;Transactions!Budgeted_Amount);(Transactions!Provider<>"")*(Transactions!Expense_Center<>"")*(Transactions!Category="Expense")*(Transactions!Budgeted_Amount<>"");""));{1\2\3\4\5\6}))160KViews0likes3Comments
Groups
Recent Blog Articles
No content to show