Formulas with two alternate states

[#1]

Hello Guys,

I have these formulas, where the field "OPTIONAL" comes from a different alternate state called "State10"

=Chr(39)&Replace(GetFieldSelections(OPTIONAL,',', GetSelectedCount(OPTIONAL)), ',' , chr(39)&','&chr(39)) &chr(39)

how do I add the alternative state to this formula???

Thank you already

[#2]

state_name::field_name

[#3]

If I go like this:

=Chr(39)&Replace(GetFieldSelections(State10::OPTIONAL,',', GetSelectedCount(State10::OPTIONAL)), ',' , chr(39)&','&chr(39)) &chr(39)

The expression appears to be wrong, what should I do?

[#4]

Try this:

=Chr(39)&Replace(GetFieldSelections([State10]::OPTIONAL,',', GetSelectedCount([State10]::OPTIONAL)), ',' , chr(39)&','&chr(39)) &chr(39)

Don't worry if it's not parsing, it just happens sometimes with set analysis

[#5]

Tried with the error but ended up still not working.

[sbaldwin]

Hi, i don't think you can use the state::field syntax with this system function, have you tried something like

=replace( '#'&Concat({State10} OPTIONAL,'#,#')&'#','#',chr(39))

Thanks

Steve

[simondachstr]

You can't use set analysis with the GetFieldSelections() function. Use an embedded Only function instead e.g.:

GetFieldSelections(Only({State10} OPTIONAL)) etc...

[#8]

It worked perfectly buddy, however, the list starts with all OPTIONALS selected, and I need that to start 'blank', with no selections at the beginning.

Is that possible?

[sbaldwin · Accepted solution]

Try:

=if(count({1} OPTIONAL) = count({State10} OPTIONAL),'blank',    replace( '#'&Concat({State10} OPTIONAL,'#,#')&'#','#',chr(39)))

[#10]

Thank you so much. Worked perfectly.