Should be an easy one

[Dittau]

If i want to filter for no data or any data in the formula tool… what do i type in to filter for no data = true/false?

[martinding · Accepted solution]

Hi @Dittau ,

Depending on how your data comes in, "no data" can either appear as nulls or empty cells.

To filter these out, try:

ISNULL([Field])

or

ISEMPTY([Field])

[Dittau]

it just comes in as blank…so i tried that with the filter and when there is data my email gets sent out but when there is not data something is not working as my emails not getting sent out.

i have a filter tool account is not empty - false (so no data) shows in account then i have a report text for body of email that connects to a horizontal layout to the email but somethings not working…any thoughts?

[RobertOdera]

Hi, @Dittau 

Consider using the IsEmpty argument per @martinding  suggestion.

IsEmpty evaluates for both Nulls and Blanks.

For your use case, insert a Union tool after the filter and union the True and Flase. That way, data should flow whether null or blank or not null or not blank.

I hope you find this helpful - Cheers.