Formula issue
- 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
Hi,
Can someone please help with a formula issue? Think it is missing ({ or something.
1st formula working:
if(Contains([Bottler Name], "ADMIRAL") AND [RB_CORP_GRP]="ADMIRAL")then [RB_BTTLR_ID] else "x" endif
2nd formula works til black words:
if [BP Billing #]="x" AND Contains([Bottler Name],"BUFFALO ROCK" and Contains ([RB_CORP_GRP],"ROCK"),[RB_BTTLR_ID]), [BP Billing #] endif
Thanks in advance,
Cheryl
Solved! Go to Solution.
- Labels:
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @CherylH
Below highlighted might be the few issue. Where its missing syntax.
if [BP Billing #]="x" AND Contains([Bottler Name],"BUFFALO ROCK") and Contains ([RB_CORP_GRP],"ROCK")
then [RB_BTTLR_ID]
else [BP Billing #] endif
Hope this helps 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try this:
if
([BP Billing #]="x" AND Contains([Bottler Name],"BUFFALO ROCK") AND Contains ([RB_CORP_GRP],"ROCK"))
THEN [RB_BTTLR_ID])
ELSE
[BP Billing #] ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Its tough because we don't know the exact purpose of the formula but this is my best guess:
if [BP Billing #]="x" AND Contains([Bottler Name],"BUFFALO ROCK") and Contains ([RB_CORP_GRP],"ROCK") then [RB_BTTLR_ID]) else [BP Billing #] endif
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Morgan_Thomas smart use of strike through on bracket ) 🙂 Had never thought of it. Great trick😀
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As soon as I type then the balance of formula goes black.
It is all in Vstring and compare numbers to number and then I throw in the X when something does not match
What can I provide you to help explain?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @CherylH ,
Yes, use a select tool before the formula to change your number fields to be numeric (Double, Fixed decimal etc.), then make sure the formula is in the correct format.
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks this did it! appreciate the help, I mean really appreciate.
