Empty Report

[Sarah_Keown]

Hi all,

would there he a specific reason why my report keeps running blank, but works under the slice condition in the app.

The report condition is as follows:

<<Start: FILTER(“Accounts”,AND([Query Status]=“On Query”,[POD Match]=“No”,ISBLANK([Procurement Check])))>><<[Order No]>>

I took the AND() condition out and put it into a slice to make sure the data was filtering correctly which it is.

The app is not deployed so the test runs are just going to the owner email and into the default file storage.

I have saved & verified to get rid of any errors causing problems but can’t seem to understand why it isnt filtering.

Report:

Slice (using same AND condition)

Am I missing something important?

[Steve]

What do you get when you Test the FILTER() expression from Expression Assistant?

[Sarah_Keown · Accepted solution]

I should have wrote in the issue has been resolved, very simple.

I was trying to match a Y/N expression as “No” instead of “N”.

Thanks!