Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using OR with IF statement in rtf template is not working as expected

edited Apr 15, 2024 7:04AM in BI Publisher Learning Center

Summary:

Using OR with IF statement in rtf template is not working as expected

Content (please ensure you mask any confidential information):

I have a requirement for my rtf template to push out multiple sheets based on BUSINES_UNIT. However certain of the business units should combine into one Business Unit sheet. My sheets are getting named correctly and split correctly, however it is not pulling the correct Business Units together into the sheets that must be combined. For exaple if my if statement on one of them read as follows <?if:(./BUSINESS_UNIT= 'CDC Estate and Facilities Management') OR (./BUSINESS_UNIT = 'CDC Logistic Park')?> I then want it to pull all the records together into the sheet as per the layout. HOWEVER it is

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!