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!