
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Display negative numbers in brackets
Hi
On the front end, I want to show negative numbers is brackets.
for eg, the number -1,100.65 , I want to display it as (1,100.65)
How do i do that?
Please help
kind regards
Nayan
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
On the Number tab of the properties screen select your expression and check Fixed to under Number Format Settings. Set the format pattern to #.##0,00; (#.##0,00)
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=if(a < 0, '(' & fabs(a ) & ')', a)
where can be a list box or input field.
change to list box or input field or value you have.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jagan
Thanks. I will try it out and let you know.
kind regards
Nayan

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
On the Number tab of the properties screen select your expression and check Fixed to under Number Format Settings. Set the format pattern to #.##0,00; (#.##0,00)
talk is cheap, supply exceeds demand


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi:
In general, copy the format from Number tab in Object Properties or Document Properties. This time, I typed those brackets and erased the minus sign. It works. If it is not currency, just erase the € sign.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi All
Thank you for your help. It worked.
kind regards
Nayan


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I've noticed this post while searching for a solution for my problem (Displaying negetive percentage values as (##%)).
Do you know why the standard aproach that you've suggested does not work for percentage values?
Would appreciate an expert's feedback.
Regards,
Vladimir
