Text Script formatter

OL Connect Professional Designer
1

Can anyone provide an example of how to format negative numbers to use a leading negative sign (dash) instead of enclosing them in paranthesis?

By default the “formatter.currency(field);” method will put “()” around negative numbers. I’m sure there is a way to supply a different, custom pattern, but I’m not finding it in the Help system.

2

Have you read this and then this?

3

In scripting it would look something like this:

results.text( 
	formatter.currency(record.fields.value, "#,##0.00 €; -#.##0,00 €")
)

When using expression something like this:

{{number value "#,##0.00 €; -#.##0,00 €"}}

Note that the standard formatting follows the Locale set for the template. Things could be as simple as changing the locale in Edit > Locale to an explicit locale (assume your document is now using en-US but for example chaning it to en-CA would show the desired result). The formatting of dates is also influenced by the locale.