I'm trying to use the GetSelectedCount() function in the 'calculation condition' of my table. I want my table to display the gage info when a GAGE_SN is selected. However in my sheet I am filtering for specific gages from my data set using the current function:
because I am using a calculated field, the GetSelectedCount(If(CRIB_NUMBER='CAB00-OR', GAGE_SN)) is not working when I make a selection of a gage. Is there a way to use an equation withing the GetSelectedCount() function?
Any help is appreciated.
Thanks in advance,
I don't know exatly what contains the field GAGE_SN but try this:
I don't think this function work with other argument than fieldname, but you can try also the extended version of your expression: =GetSelectedCount(If(CRIB_NUMBER='CAB00-OR', GAGE_SN))>0
getselectedcount() takes fieldname as input.
Have you tried using GetSelectedCount(GAGE_SN) instead? I think this should work even if your list of GAGE_SN is derived using above formula.
I tried that and it works but I am trying to make the selection column to be the calculated field =If(CRIB_NUMBER='CAB00-OR', GAGE_SN).
here's what my table looks like:
As you can see I have two columns with the same information. I am using the first column to only show the gages I am concerned with. That being said I cannot get rid of it. In my second table I wish to show the gage info when a gage is selected by the user. However because the first column is a calculated field when I try using a function in the data handling portion of my table I need to use an actual field such as GAGE_SN. I am trying to get rid of the the second column and find a way to be able to use the calculated field in data handling. Is this possible?
This is a long shot but is there a way to use a label name instead of a field name when using getselectedcount?
Or is there by an chance any other functions that I would be able to use instead of getselectedcount that could use an arguement name?
So you want a list of gages and a table with details right?
i suggest you to make a filterpane with gages (or any other object, where you can filter the dimension) and distinctly a table with the calculation condition, with getselectedcount(Gage_sn)=1 or the Gysbert's suggesion.
Am I miss somehing?