Skip to Content
Former Member
Jan 06, 2015 at 01:40 PM

How to filter a formula



I have a query with 5 columns. 1 column is based on a formula that can hold 1 or 0.
Now I only want to show the data if 'this' column is 1. Does anyone know how to do that?

it's basically like putting a restriction on the column saying only take 1. But since it's a formula it doesn't work. Also tried adding a condition saying

'this column' == 1, but these returned nothing.