Filter in ReportStudio

[Jaspire]

Hi All,
I created a report having Prompts and a Filter. The prompts are working good. But when I run the report I am getting all the values in the report including those which have the qantity = 0. But I gave a filter condition with Quantity= 0 .
Can you suggest me any cause why this can happen?

Thanks

[almeids]

(I'm assuming you have a typo in the filter above and don't want the zeroes)
Perhaps the quantities in the database are null rather than 0.
Try filtering with IS NOT NULL or IS NOT MISSING.

[Jaspire]

Thank you