Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Referencing a Blank cell (with @@)


Sometimes you want to filter an NL function based on the contents of another cell or the output of another NL function, where either of which could be a blank value.

The NL function does not allow you to use blank filters, and you will get a #VALUE error message if you fill in a FilterField parameter and leave the corresponding filter blank.

When you are using a cell reference to filter on a blank value, you just need to change the syntax a little.

Any time you are going to reference a cell that has special characters or could be blank, simply put "@@" in front of the cell reference.


let's assume that we want to use the contents of cell D5 in our filter - but the contents of that cell could be blank.  Here's how:

When D5 is blank, the function will use "@@", instead.  This value is interpreted by your datasource to mean "blank".
Was this article helpful?
4 out of 4 found this helpful