RTF Template Various Number Formats

Double click on element, and

BI Publisher Properties > Formatting [Number] > Format

1. You want to show Negative Number -200.34 as (200.34) then enter below into format.

#,##0.0000;(#,##0.0000)


2. If Number is just decimal place to 0000, then place #,##0.0000

3. In case there is number which length is long like 20 char long, then it will display as scientific , to avoid it use Force LTR check box, which will read element from Left to Right (like Arabic style), and it will be read as text instead of number, and you can also check the code generated after applying this check box.

Also any operations being done on xml element , first it should be converted to number type.

<?number(invoiceAmt) - number(amtPaid)?>