nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Format currency withHTML

HSMorales

I have a text box with Dynamic Text HTML "The amount you owe is : <VALUE-OF>row._outer["INV_TOTAL"]</VALUE-OF>."

where INV_TOTAL is a currency value.

What is displaying is "The amount you owe is : 166.6."

I would like it to display "The amount you owe is : $166.60."

What syntax do I need to get it to format INV_TOTAL as currrency ??

Thanks

BIRT 3.7.0

Find more posts tagged with

Comments

mwilliams

This should do it:

The amount you owe is : <VALUE-OF format="$#,##0.00{RoundingMode=HALF_UP}">row._outer["INV_TOTAL"]</VALUE-OF>.

HSMorales

Works great. Exactly what I needed. Thanks for all your help.