Oracle Analytics and AI

Martha Wasylynchuk

Hi,

I'm trying to update my offer letter templates in Oracle. These are done through BI Publisher in Word.

I'm looking for a syntax that will print one paragraph if Location_Name = one of the 4 different locations, and if Location_Name is NOT = one of the 4 locations, then print a different paragraph.

This is what I had but it's not working:

C<?if: LOCATION_NAME IN('location A', 'location B', 'location C', 'location D')?>

Paragraph 1

EC

C<?if: LOCATION_NAME NOT IN('location A', 'location B', 'location C', 'location D')?>

Paragraph 2

EC

Gaurav Bharadwaj-Oracle

Hi @Martha Wasylynchuk ,
It seems like your syntax is incorrect.
Kindly look at this documentation for the correct syntax with examples.
Conditional Formatting in RTF

You need to use IF-ELSE-IF Statement here to achieve what you are looking for.

An Example :
<?xdofx:if AMOUNT > 1000 then 'Higher'
else
if AMOUNT < 1000 then 'Lower'
else
'Equal'
end if?>



If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

Regards,
Gaurav