Slice expression referencing child table

[tcanelli]

What’s wrong with this?

AND(ISBLANK([Bunk Number Assigned]), ISNOTBLANK([Related DEMO Personnel Time in Time Out Sheets][Check In Time]), ISBLANK([Related DEMO Personnel Time in Time Out Sheets][Check out Time]))

It doesn’t give an error, but doesn’t display any data and I should show one person checked in waiting on a bunk number.

My bunk info is in the parent table and the time in/time out is the child table.

[Aleksi]

Instead of using ISBLANK or ISNOTBLANK, try to use COUNT([Bunk Number Assigned])=0 etc.

[tcanelli]

Not sure I understand. Count on all three of those items?

I’m creating the slice on the personnel sheet where the bunk info resides but need it filtered based on the time table.

[tcanelli]

Think I got it! Had to change around the table for the slice! woohoo

[Aleksi]

Excellent