Filter a list of Value in a dimension in Straight table

[#1]

Hi,

I used following formula to filter out any data related to "Cancelled",
"Pending Cancelled" and "Pending Cancellation" in a dimension
in Straight table. The formula works, but it created a "-" in every
entry that contains criteria mentioned above. Is there a way to completely
remove entries with "Cancel', "Pending Cancellation" and
"Pending Cancelled"?

IF(NOT MATCH(CAP Status, 'Cancelled','Pending Cancelled','Pending Cancellation'),CAP Status)

Thanks!

[Nicole-Smith · Accepted solution]

[Anonymous]

Jasmine

On the Presentation tab of your Straight Table for the Null Symbol replace the - with a space.

Best Regards,     Bill

[sebastiandperei]

Layout of the object, Null Symbol, put a space

[#5]

Thank you so much for your quick response.