Expression Usage
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can I use the below expression in the Formula Tool?
IF [System] = "1" or [System] = "2" THEN
[Owner] = "Brad Pitt"
ELSE [Owner] = [Primary]
ENDIF
Basically, I need to check if the field System is either 1 or 2, the field Owner must have the name "Brad Pitt" else, the field Owner must have the name in another field called Primary.
Appreciate every help that I can get
Solved! Go to Solution.
- Labels:
- Data Investigation
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
in the formula tool add colunn called User and use the following formula
IF [System] = "1" or [System] = "2" THEN
"Brad Pitt"
ELSE [Primary]
ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
All the fields mentioned here are Strings. The above statement returns 0 against the field Owner.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
your formula is wrong.
Owner must be the name of the column in the formula tool
check the formula I posted above
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @geraldo
The below solution half works. I mean
IF [System] = "1" or [System] = "2" THEN ==> This is not working as expected
whereas
IF [System] = "1" THEN ==> this works
Anyway I can make the 1st statement work?
By the way, I have already created a new column called Owner
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @geraldo
It worked like a charm
![](/skins/images/18F3BF3EB54AD3C2739B5AA9B77A7F97/responsive_peak/images/icon_anonymous_message.png)