BI Publisher (MOSC)

MOSC Banner

etext format_number is not working

edited Aug 8, 2018 5:06PM in BI Publisher (MOSC) 4 commentsAnswered

Hi,

I have tried use format the column (as below), which is of data type 'Alpha'.  Am getting the below error, in the template viewer.   and I am also getting ??????????? in my output file. However, the number is not getting formatted. I can't use the data type as Number. Please help me. Thanks. Sridhar

453

15

Alpha

L, ‘ ‘

IF DocumentPayableCount = 2 THEN

Format_number(DocumentPayable[2]/TotalDocumentAmount/Value,”999,999.00”)

ELSE

‘ ‘

END IF

070816_162722777][][ERROR] expression:<lpad((CONVERT_CASE(TO_CHAR((IF DocumentPayableCount = 2 THEN

Format_number(DocumentPayable[2]/TotalDocumentAmount/Value,"999,999.00")

ELSE

' '

END IF)),'UPPER')),15,' ')> is invalid

[070816_162722793][][ERROR] expression:<> is invalid

Time: 0.219 sec.

Successfully generated xdo445127950734697854.txt

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