Row Filter Condition on slice not working

[PJMatelli]

I cannot seem to find an answer that helps with my issue: I have a ref column (Facility) to a slice (refFacility). I am trying to display (in read only status) just the “A” facilities. It is displaying the Key field of those records that are “I” status…I am so confused as to why this is not working…Screen shots below:

[Marc_Dillon]

Do you have a valid_if or suggested values expression set for the [Facility] Ref column?

[PJMatelli]

I just have the sorting in the Valid If:

[PJMatelli]

And, why would I need the Valid If … shouldn’t the slice handle it?

[Marc_Dillon · Accepted solution]

Your expression in Valid_If is pulling in all key values from the base table, not just the slice ones, but since the Ref is pointed to a slice, certain key values don’t have any valid reference links, thus they appear with the yellow exclamation.

Change tblFacility to refFacility in the valid_if expression, and you should be good to go.

[PJMatelli]

BRILLIANT! Thank you so much…