How to set the num.currency{} such a way that it will display "-" sign for Negative numbers instead of "()" | Community
Skip to main content
endreddy
endreddy
February 25, 2016
Solved

How to set the num.currency{} such a way that it will display "-" sign for Negative numbers instead of "()"

  • February 25, 2016
  • 4 replies
  • 7542 views

Hi Adobe folks,

I am working on a Adobe invoice form, where in few currency fields might need to show as "-" if it is negative number.

I am using Display pattern num.currency{}, but its displaying it as ($1,234,567.89), I want this to display as $-1,234,567.89

Can anyone please let me know how to achieve this.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by _Bruce_Robertson

    Hi,

    I did wonder if it would be that easy.  It does seem that US and Hong Kong are the only ones that use the brackets for negative numbers.  The Australian currency displays as you want.  Maybe you can go into the XML Source and change the line <numberPattern name="currency">$z,zz9.99|($z,zz9.99)</numberPattern> to <numberPattern name="currency">$z,zz9.99</numberPattern> .  Which is how the Australian one looks ... would need some testing though.

    Or maybe you can have the decimal field hidden and display a text field with a calculation like DecimalField.formattedValue.replace(/[()]/g,"");. Do you need to line up the decimal points?

    Bruce

    4 replies

    _Bruce_Robertson
    _Bruce_Robertson
    Level 10
    February 26, 2016

    Hi,

    Try using a display pattern of num{$z,zzz,zzz,zzz,zz9.99}

    Regards

    Bruce

    endreddy
    endreddyAuthor
    February 26, 2016

    I can use num{$z,zzz,zzz,zzz,zz9.99} to make it display -ve sign, but that defeats my main purpose, which is formatting the amount as per the Currency code. (For example if its USD it prints with 2 decimals like 22.33, and if its Japan currency, it prints without decimals 22)

    That's the reason i wanted to use num.currency{} but want to print -ve numbers without braces.

    Any help in achieving the "-"ve sign instead of "()" using num.currency{} would be highly appreciated !!

    endreddy
    endreddyAuthor
    February 26, 2016

    I can use num{$z,zzz,zzz,zzz,zz9.99} to make it display -ve sign, but that defeats my main purpose, which is formatting the amount as per the Currency code. (For example if its USD it prints with 2 decimals like 22.33, and if its Japan currency, it prints without decimals 22)

    That's the reason i wanted to use num.currency{} but want to print -ve numbers without braces.

    Any help in achieving the "-"ve sign instead of "()" using num.currency{} would be highly appreciated !!

    _Bruce_Robertson
    _Bruce_RobertsonAccepted solution
    Level 10
    February 27, 2016

    Hi,

    I did wonder if it would be that easy.  It does seem that US and Hong Kong are the only ones that use the brackets for negative numbers.  The Australian currency displays as you want.  Maybe you can go into the XML Source and change the line <numberPattern name="currency">$z,zz9.99|($z,zz9.99)</numberPattern> to <numberPattern name="currency">$z,zz9.99</numberPattern> .  Which is how the Australian one looks ... would need some testing though.

    Or maybe you can have the decimal field hidden and display a text field with a calculation like DecimalField.formattedValue.replace(/[()]/g,"");. Do you need to line up the decimal points?

    Bruce

      Terms & ConditionsAccessibility statement

      Loading footer...