|Issue||Filtering for Blanks in a Jet Reports Formula
||To filter for blanks is to put "@@" in front of the cell reference or value.
Sample function is: A user wishes to display the Description field for an Item No. that has a No. value of Blank. There is a formula that returns the No. from the Item Table in C4.
"@@" & C4 Use "@@" & if the cell reference could be blank and you want to filter for blank field values.
The formula will filter such as:
If C4 was 1001 The formula would translate as a filter for an Item.No. = 10001
If C4 was blank or empty The formula would translate as a filter for an Item.No. = ' (two appostrophes)
Modified on: Mon, Dec 12, 2016 at 3:25 PM
Did you find it helpful?Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.