BI Publisher (MOSC)

MOSC Banner

Excel Template - Calculation in XDO_METADATA

edited May 29, 2018 4:39PM in BI Publisher (MOSC) 3 commentsAnswered ✓

Hello,

We are on BI Publisher part of OBIEE 11.1.1.7.150120 on Linux.

I am defining an Excel Template and I have defined two summary fields in XDO_METADATA tab as follows:

XDO_?XDOFIELD18?         <?sum(.//PRICE)?>

XDO_?XDOFIELD19?         <?sum(.//COST)?>

Note that the PRICE and COST columns are on two different tabs in the template.

Now, based on these two summary fields, I need to calculate a % such as:

(PRICE - COST)/PRICE * 100

I am unable to get this to work in the XDO_METADATA tab. What is the correct syntax to be used in this case?

I tried the following, but it doesn't work.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center