BI Publisher (MOSC)

MOSC Banner

Calculation in BI publisher template assistance required

edited Jun 15, 2016 6:29AM in BI Publisher (MOSC) 1 commentAnswered

Hi all,

We are trying to calculate fields to get balance in the report but still it does not work .Could you help  us in achieving the result using variables ,how,where to declare them and get them..the proper syntax etc..

for eg: This is one of the syntax we tried...

<?xdoxslt:set_variable($_XDOCTX, 'LVar',xdoxslt:get_variable($_XDOCTX, 'a')- xdoxslt:get_variable($_XDOCTX, 'b')+xdoxslt:get_variable($_XDOCTX, 'c') ) ?>

where a - BAL_AMT   ,  b - PYMNT_AMT, c- INVOICE_AMT

but we get different kind of errors like Cannot convert to number, Error in extension function arguments

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