Reports Excluding Empty Values

đź’¬ General Discussion
1

Hi there,
We are trying to create a report that excludes blank values from a field, however when i try to create a condition there is no option to select is null, or isempty
any ideas how i can remove these blanks from my reports?

thanks
jamie

2

just use NotEqualTo and leave empty the value

best regards

3

Doing this remove the whole line if one field is empty.

How to remove only the empty fields and keep other fields of the same line that have values ?

Is there any other solution than processing the exported CSV with a macro ?

Thanks,

4

@antorogiers if you’re specifying “conditions” in the Report, it’s supposed to be affecting entire rows.

But if you don’t specify a condition and the row get’s printed, then only filled fields will appear… I don’t see what your problem is.

Example: if you make report for contacts, including a column for Phone number, if there is no Phone number value for a specific contact, then that column will be blank, which is what you want, right?

5

If we want to do certain campaigns on Targets with active mobile numbers,
How can we do a report were we exclude “empty” mobile numbers?
Ive noticed other platforms use a more advance conditions options like “empty”, “not empty” etc.

Thank you