Calculated field to display negative answer in parentheses instead of using the (-) sign | Community
Skip to main content
nowackem
New Participant
May 17, 2021
Solved

Calculated field to display negative answer in parentheses instead of using the (-) sign

  • May 17, 2021
  • 1 reply
  • 837 views

I have a numeric field on a form with a calculation. The calculation works fine but if the answer is negative, I need it to display as (24.36) as opposed to -24.36. Can someone let me know how this is done? Thank you in advance!

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 nowackem

Ok I answered my own question. In Patterns under Display put the () inside {} like this: num{(z,zzz,zz9%)} My example needed percentages so thats I what I used.

1 reply

nowackem
nowackemAuthorAccepted solution
New Participant
May 17, 2021

Ok I answered my own question. In Patterns under Display put the () inside {} like this: num{(z,zzz,zz9%)} My example needed percentages so thats I what I used.

kautuk_sahni
Employee
May 18, 2021
@nowackem, Thank you for sharing answer with community. This would help in posterity. Keep contributing to the AEM community.
Kautuk Sahni