9 Replies Latest reply: Jan 27, 2014 5:41 AM by Alan Farrell

# Change negative to () help.!!!

Hi Folks ,

I need to covert all negative numbers in my pivot table to () for example -8.3 should appear as ()8.3. Any idea how to do it.

At present my number format is #.##0,0

• ###### Re: Change negative to () help.!!!

you could use FABS Function around the Expression.

or change the number format to

'#.##0,0;(#.##0,0)'

• ###### Re: Change negative to () help.!!!

hi,

Try using

if(Sum(exp)<0, '()'&fabs(sum(exp)), sum(exp))

HTH

-Shruti

• ###### Re: Change negative to () help.!!!

Thanks Alan it worked fine .

• ###### Re: Change negative to () help.!!!

Hi Amit,

Thanks

Alan

• ###### Re: Change negative to () help.!!!

use below:

Replace(FieldName,'-','()')

for simple presentation change. It won't affect total sums.

• ###### Re: Change negative to () help.!!!

As Alan said, modify your number format.

expression for >0 number ; (semi colon) expression for < 0 numbers

so you will have:

Fabrice

• ###### Re: Change negative to () help.!!!

hi

try to use fabs() function

example-

='()' & fabs(-8.3)

then output is

()8.3

hope this helps you.

• ###### Re: Change negative to () help.!!!

Type the number format  like below

• ###### Re: Change negative to () help.!!!

Hi Amit,

Why don't you use

=if(Sum(Sales)<0,'('&Sum(Sales)&')',Sum(Sales)).

Cheers,

Naresh