- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Formulas with two alternate states
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
=if(count({1} OPTIONAL) = count({State10} OPTIONAL),'blank', replace( '#'&Concat({State10} OPTIONAL,'#,#')&'#','#',chr(39)))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
state_name::field_name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tried with the error but ended up still not working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can't use set analysis with the GetFieldSelections() function. Use an embedded Only function instead e.g.:
GetFieldSelections(Only({State10} OPTIONAL)) etc...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
=if(count({1} OPTIONAL) = count({State10} OPTIONAL),'blank', replace( '#'&Concat({State10} OPTIONAL,'#,#')&'#','#',chr(39)))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much. Worked perfectly.