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

Which function can be used to display only one value from multiple values result?



Display the first value from a result including many values

Content (required):

We're using an OTBI analysis for delayed PO deliveries and we've supplier's details displayed in it.

Yet, some suppliers have more than 1 contact/email address. So whenever we've only one contact/email the fields are correctly populated with it. But in the other case (multiple contacts/emails) the fields are returned empty.

So we've tried differente function (Min, Max, RMax, RMin) which actually return the Min/Max value from the list displayed/fetched in the report and not from the supplier contacts as per each PO.

We also looked up the function FIRST it's not available anymore in OTBI.

Howdy, Stranger!

Log In

To view full details, sign in.


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