etext format_number is not working
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