Business Objects 5.1.6 IF Statement Help

[Leohere]

Hi everyone. I'm a new so sorry if this is an easy question. I have sales report where I have a State and Country column. If the State column says PR or VI I need the Country column to say Puerto Rico or Virgin Islands instead of showing what it currently shows which is USA.

I entered the formula = If (<Account Bill-to State><>"PR") Then <Account Bill-to Country Name>Else "PUERTO RICO" which give me Puerto Rico but I can't figure out how to get in the part for the VI.

Any ideas ?

 

[CoffeeManOhYesIAm]

This is kinda clunky, but it might just work:

If (<Account Bill-to State><>"PR")
Then
If (<Account Bill-to State><>"VI")
Then <Account Bill-to Country Name>
Else "VIRGIN ISLANDS"
Else "PUERTO RICO"

Good Luck!

 

[Leohere]

Awesome it worked ! All hail CoffeeMan

 

[synapsevampire]

For readability you might prefer:

If (<Account Bill-to State> = "PR") Then
"PUERTO RICO"
else
If (<Account Bill-to State> = "VI") then
"VIRGIN ISLANDS"
else
<Account Bill-to Country Name>

It appears that you're asking BO questions in a Crystal forum, an increasing mistake since BO acquired them, however there is a true BO forum here:

forum393

-k

 

[Leohere]

Thanks again.