Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data like in table below. I want to display location in Text object like if you select rank 111 or Rack or any associated field from search object text object should show location as Michigan, Select 121 show Ohio, Select 131 show California..etc. If i don't select anything show text objects as empty.
Location | Rank | Rack |
Michigan | 111 | A |
Ohio | 121 | B |
California | 131 | C |
Chicago | 141 | D |
Hi @pinky1234
Might be, you have more than one location per rank or rack.
Try like below
=if(GetselectedCount(Rank)=1 or GetSelectedCount(Rack)=1, Count(Distinct Location, ','), '')
@pinky1234 you can simple call, =Location text object
I tried that way and it didn't work. Even i tried Concat function but all locations are showing in text object.
hi, in a text object try :
=only(Location)
as is possible to have more than one Michigan value location
I tried only function and it didnt work.
Hi @pinky1234
Might be, you have more than one location per rank or rack.
Try like below
=if(GetselectedCount(Rank)=1 or GetSelectedCount(Rack)=1, Count(Distinct Location, ','), '')