XML Database (MOSC)

MOSC Banner

NAN retunred on calculating a figure

edited Aug 15, 2011 9:11AM in XML Database (MOSC) 1 commentAnswered
Morning All,

I am trying to create a calculation column  but for some rows i get a NAN.

I think this is happening when the figures i am trying to calculate from contain a NULL value.

Column i am trying to achieve is   Debit  - Credit =  Net

Debit is calculated using code :-  <?xdofx:nvl ((JRNL_LINE_DR[.!='']),0)?>

Credit is calculated using code :-  <?xdofx:nvl ((JRNL_LINE_CR[.!='']),0)?>

Net is  :-  <?choose:?><?(JRNL_LINE_CR - JRNL_LINE_DR).!=''''?><?format-number:(JRNL_LINE_CR - JRNL_LINE_DR).!='''';'999G990D99'?><?otherwise:?>0.00<?end otherwise?><?end choose?>

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