Display blank values only

[Kuroshi]

I have a report with search function. Is it possible to use a one field and be able to search for the value and a blank value as well? I am using a dropdown field and I tried adding 'Blank' in the display and leave the value as blank but it is displaying all the records instead of displaying the blank values only. Can you help?

[Barbie]

Hi @Batchini,

What we can do as a workaround is to create criteria in your Field A and make the other criteria set as a checkbox that once checked, it will display the blank values only. Please refer to these sample screenshots:
1.
2.

The first criteria will be the dropdown field and the second criteria will be the checkbox which will check if the records are blank.

I hope this helps.

- Barbie

[telly]

Hi @Batchini,

Just to add, you can also filter the the blank value by enabling it on the advance tab of the field in the search form: