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

How to add multiple IF function in the Field Browser using Microsoft Word - BI Publisher?

Received Response

In my RTF template, I'd like to put a message for employees who are not belong to a specific department:

However, in our case, some employees under 'ABC Expert' department still getting this message because they are also belong to other departments. Please see below example:


Employee 1: Belong under 'ABC Expert' and 'XYZ Expert' departments.

Employee 2: Belong only under 'ABC Expert' department.

Expected outcome:

Both employees should not receive the red message because they are both under 'ABC Expert' department.


Employee 1 receives the red message because he is also under 'XYZ Expert' department. So, I'd like to add another function for my RTF Template to prevent employees with multiple departments from getting this red message.

Howdy, Stranger!

Log In

To view full details, sign in.


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