Hide rows value with a condition

The filter condition '=IF( AND( [Survey].Completed = TRUE, ISBLANK(LOOKUP([_THISROW], "Survey", "Row ID", "Satisfaction Level")) OR LOOKUP([_THISROW], "Survey", "Row ID", "Satisfaction Level") <> "", ISBLANK(LOOKUP([_THISROW], "Survey", "Row ID", "Feedback")) OR LOOKUP([_THISROW], "Survey", "Row ID", "Feedback") <> "" ), "", [Ticket ID] )' of table slice 'Visible Ticket ID' must return true or false.

This is an error message that shows, but what i want is to create a slice that will hide the Ticket ID if the Survey Form was completed with the specific Ticket ID.

0 1 23
1 REPLY 1

I see several syntax errors in your expression e.g.

[Survey].Completed which should be i guess [Survey].[Completed].

OR without () and other instances

Please correct all of them. Also the result of the expression should be a TRUE or FALSE value. In your case its either returning blank or [Ticket ID]

Top Labels in this Space