Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 2
nowackem
Level 2

Likes

2 likes

Total Posts

39 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
nowackem
Level 2

Likes

2 likes

Total Posts

39 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
nowackem
Level 2

17-05-2021

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!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
nowackem
Level 2

Likes

2 likes

Total Posts

39 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
nowackem
Level 2

Likes

2 likes

Total Posts

39 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
nowackem
Level 2

17-05-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.

Answers (0)