Right now I have a field on a table, "ID", that is being filtered by an if statement. I leave 'include null values' unchecked and this lets me filter out the other fields I don't want. My problem is that when I select the drop down menu of those other fields, they are showing values that are not available. I know I can just add use the same conditional for these fields as I did for ID but that doesn't seem very maintainable at all, we are talking about many fields on many tables.
I was hoping I could make that conditional a variable.
So the variable would be vCheckDate = if(DateA > Today(), ($1))
and I would use it like $(vCheckDate([ID])
but this is not working. Any ideas how I can get this to work or how to stop those drop downs from showing values that aren't available?
Thank you
