I have a few cross-company baq’s that filter data down to the current month. The issue I’m having is that no lines will be returned during the first day of the month for these baqs. I need them instead to return a 0 for each company so that there are actual lines returned. Has anyone had any success with this or has a workaround for it?
1 Like
if you do queries as Sub-Queries, and then consume the sub-queries in a top query, you can put display the values as calculated fields, and then put something like this in the calculation:
iif (myColumn= null ,0,myColumn)
This will replace those blank values with zeros
1 Like
the SQL statement would be
IsNull(MyTable.MyColumn, 0)
3 Likes
Jason is right… I was half way in c# and half in SQL land. hahah
Thank you both!
Apologies for the hijack here, but what if you wanted to go the other way. Show zeros as blank?