- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if with multiple value of field
Hello to all,
I have a problem.
I have a field called SCENARIO and I would like to save the value of this in a variable, but according to the following condition:
- If the SCENARIO field contains the following values "FC 1" and "FC 2" and "FC 3" then I want the variable to contain only the value "FC 3".
- If the SCENARIO field contains the following values "FC 1" and "FC 2" then I want the variable to contain only the value "FC 2".
- If the SCENARIO field only contains "FC 1" then I want the variable to contain only the value "FC 1".
I tried with an if but without success.
Thank you,
Livio
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where are you going to be using this? On the front end? May be this
MaxString(SCENARIO)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Front end, but in the field SCENARIO, I have other value, so i think that MaxString(SCENARIO) not working in my case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try using =MaxString(SCENARIO)
Thanks,
Pooja
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this
If(SubStringCount(Concat(DISTINCT '|' & SCENARIO & '|'), '|FC 3|) = 1, 'FC 3',
If(SubStringCount(Concat(DISTINCT '|' & SCENARIO & '|'), '|FC 2|) = 1, 'FC 2',
If(SubStringCount(Concat(DISTINCT '|' & SCENARIO & '|'), '|FC 1|) = 1, 'FC 1')))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not working again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My bad, I missed single quotes
If(SubStringCount(Concat(DISTINCT '|' & SCENARIO & '|'), '|FC 3|') = 1, 'FC 3',
If(SubStringCount(Concat(DISTINCT '|' & SCENARIO & '|'), '|FC 2|') = 1, 'FC 2',
If(SubStringCount(Concat(DISTINCT '|' & SCENARIO & '|'), '|FC 1|') = 1, 'FC 1')))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I know, I corrected it but not working too
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would you be able to share a sample or image of where you are using this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- « Previous Replies
-
- 1
- 2
- Next Replies »