Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

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

Thanks in Advance.!!!

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

you could use FABS Function around the Expression.

or change the number format to

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

View solution in original post

9 Replies
rustyfishbones
Master II
Master II

you could use FABS Function around the Expression.

or change the number format to

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

Not applicable

hi,

Try using

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

HTH

-Shruti

AbhijitBansode
Specialist
Specialist

use below:

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

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

Not applicable

As Alan said, modify your number format.

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

so you will have:

num(your exp, '#,##0.0;(#,##0)', '.', ',')

Fabrice

Not applicable

hi

try to use fabs() function

example-

='()' & fabs(-8.3)

then output is

()8.3

hope this helps you.

sudeepkm
Specialist III
Specialist III

Type the number format  like below

negativeformat.png

NareshGuntur
Partner - Specialist
Partner - Specialist

Hi Amit,

Why don't you use

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

Cheers,

Naresh

amit_saini
Master III
Master III
Author

Thanks Alan it worked fine .

rustyfishbones
Master II
Master II

Hi Amit,

Please mark the answer as Correct and also any other helpful answers, it will help other users find the answers they are looking for too

Thanks

Alan