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

Forum|Forum|4 years ago
May 17, 2021
1 reply
838 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.

nowackemAuthorAccepted solution

Level 5

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.