Hi there,
Initally in section access for variable ACCESSDETAIL I do have 'Y' and 'N'.
With that a text box use to show when the value is "Y"
thus in the layout condition - this expression is used
=SubStringCount('*|Y' , MinString({$<NTNAME={$(=upper(OSUser()))}>} ACCESSDETAIL))
But now the scenario change , like ACCESSDETAIL can have value like
![ashmitp869_0-1655881252576.png ashmitp869_0-1655881252576.png](/t5/image/serverpage/image-id/82342i8C246A8F915214E3/image-size/medium?v=v2&px=400)
So now when a user have this three value , this expression is not working
=SubStringCount('*|Y' , MinString({$<NTNAME={$(=upper(OSUser()))}>} ACCESSDETAIL))
My req is, if ACCESSDETAIL contain "Y" , then the condition or expression should work -
=SubStringCount('*|Y' , MinString({$<NTNAME={$(=upper(OSUser()))}>} ACCESSDETAIL))
When selecting a user the ACCESSDETAIL value is N OR Y
![ashmitp869_1-1655881375770.png ashmitp869_1-1655881375770.png](/t5/image/serverpage/image-id/82343i05B276C148A63A1E/image-size/medium?v=v2&px=400)
![ashmitp869_2-1655881433304.png ashmitp869_2-1655881433304.png](/t5/image/serverpage/image-id/82344iE642065098DDDDED/image-size/medium?v=v2&px=400)
But in this scenaio,it having more that one value
![ashmitp869_3-1655881489334.png ashmitp869_3-1655881489334.png](/t5/image/serverpage/image-id/82345i0C2AE9ACF41E1E6D/image-size/medium?v=v2&px=400)
How to pick Y in this case from this condition
=SubStringCount('*|Y' , MinString({$<NTNAME={$(=upper(OSUser()))}>} ACCESSDETAIL))
Thanks in advance