BI Publisher (MOSC)

MOSC Banner

Add a calculated column

edited Dec 17, 2015 10:39AM in BI Publisher (MOSC) 11 commentsAnswered

Hi Kevin,

I have a column for Gross Revenue and a column for Gross Cost in a table layout.  I want to have a variable column added for Net Profit.  I did that by dropping in a column called foreign unit cost and applied a custom formula to subtract cost from revenue.  This works but when I tried to apply a subtotal in a grouping the calculated subtotal is incorrect.  What is the correct method to add a column to a table for calculated data? 

Thanks!!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center