Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
OTBI Formula Help — Cloud Customer Connect
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 Formula Help

Received Response
29
Views
1
Comments
edited Feb 26, 2021 6:56PM in Reporting and Analytics for ERP 1 comment

Summary

Formula help for custom columns

Content

Hello,

I want to add a couple of custom columns to my OTBI analysis which have formulas in them and I was wondering if someone could help with how I phrase the formulas. I have written them in excel language below. Any help would be very much appreciated. It would also be good to know if they aren't possible.

Formula 1:

=IF(Column A="ABC",Column B,Column C) - both columns B & C are numeric

Formula 2:

=COLUMN A&" / "&COLUMN D - I want to combine the info from two columns to make a mapping

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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