Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a text box that displays the list of current selections next to a chart. The syntax I use is below. The key thing this also does is state "All" if the field is has no selections. What I want to do is do exactly the same but with the previous selection. I feel this should be possible using set analysis but thus far I have been unsuccessful in producing this effect.
Has anyone achieved anything like this?
=
if(isnull(GetFieldSelections(NodeName)),
'Current Group ' & chr(10) &
'‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾' & chr(10) &
'All',
'Current Group ' & chr(10) &
'‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾' & chr(10) &
chr(183) & Capitalize(Concat(Distinct NodeName
, chr(10) & chr(183))))
Argh just tried this
=
if(Count
({$1}NodeName)=Count({$1<NodeName=>}NodeName)
,
'Previous Group ' & chr(10) &
'‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾' & chr(10) &
'All',
'Previous Group ' & chr(10) &
'‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾' & chr(10) &
chr(183) & Capitalize(Concat(Distinct {$1}NodeName, chr(10) & chr(183))))
And it seems to work....