Formula issue

[CherylH]

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 

[atcodedog05]

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 🙂

[dougperez]

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

[Morgan_Thomas · Accepted solution]

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

[atcodedog05]

Hi @Morgan_Thomas smart use of strike through on bracket )  🙂 Had never thought of it. Great trick😀

[CherylH]

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?

[mceleavey]

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.

[CherylH]

Thanks this did it! appreciate the help, I mean really appreciate.