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

OTBI Report - Phone logic

Hi Team,


I have one report have couple of assignment details, Now I have to add one column phone number.

Criteria to fetch phone number is, If the work mobile number is available, fetch the work mobile number. Otherwise, if the work desk number is available, fetch the work desk number. If both are not available, it should be NULL.

How to do this in OTBI report?

Thanks.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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