BI Publisher (MOSC)

MOSC Banner

SUM() fn is forcing exponential notation on the result in etext template regardless of formatting sp

edited Mar 20, 2020 3:34PM in BI Publisher (MOSC) 12 commentsAnswered ✓
this is a payment etext template used to generate electronic payments to the bank. The bank has a requirement of a specific algorithm to calculate a hash total on the sum of the recipient account numbers:

1) take the first 15 characters of the account number (i am usign substring for this - no problem here)

2) any non-numeric embedded character must be replaced with a 1  (i am using a series of replace statements for this - again, no problem)

3) ignore any trailing blanks, do not convert them - no problem here

4) sum the account numbers produced by steps 1,2,3 - here is the problem. The sum function is always producing an output in expenonential notation, I.E. 1.234111573421E12   I cannot get this to format back to its proper format.

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