Hi,
Please can you help? I am trying to create a filter to filter out BLANK Jet table builder, and I cant find how to.
I need to not return blank in quantity as its returning #DIV/0! in my table and ruining my report.
I have the latest version of Jet Professional.
Please help!
Hello Danny -
Here's an example showing customers from my database:
Several have blanks in the Currency Code field. I want to filter those out.
Within the Table Builder, I ensure that the table I want to filter on is selected (in this case I'm only using a single table), and click Add Filter:
I then select the field I want (Currency Code) and select the filter of Equals and <>@@ {see the article about Blank Filters for more information}:
Now, when I run my report:
Those records with a blank Currency Code field are excluded.
When I try to run, this is returned - Invalid filter "<>@@".
Hi Danny -
In a Dynamics NAV database, that would usually indicate that the field is a numeric field - meaning that NAV considers it impossible for that field to be blank (regardless of the fact that - for whatever reason - there are records where that field is blank).
Given the situation you describe, the option I would take would be to modify my formula to take into account the possibility of an error in the calculation.
For example, here I have a table which shows #DIV/0! errors in my formula:
apparently, there are some records in my data where Remaining Amount is zero or blank.
I can adjust the formula to account for that:
Now, when I run the report...
... instead of error notations, I see the value that I placed in my IFERROR function.
Hi All,
I think i have a similar issue, and i can't get to the solution as far as i'm trying. My issu is in picture in the following pic
I've used the table builder (as per the picture below) and i changed the function for the Quantity and Invoiced quantity, since i wanted the sum of Item Ledger entry for each item in the Item table.
So far everything is great (previously i started from the Item ledger entry, but i couldn't sum/group this fields by item), my only issue is that i would like to "filter" the query in a way that when the report get's run, is not showing the lines where the QTY is 0.
Thx in advance for the help!
Regards,
Oliver