Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.!!!
you could use FABS Function around the Expression.
or change the number format to
'#.##0,0;(#.##0,0)'
you could use FABS Function around the Expression.
or change the number format to
'#.##0,0;(#.##0,0)'
hi,
Try using
if(Sum(exp)<0, '()'&fabs(sum(exp)), sum(exp))
HTH
-Shruti
use below:
Replace(FieldName,'-','()')
for simple presentation change. It won't affect total sums.
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
hi
try to use fabs() function
example-
='()' & fabs(-8.3)
then output is
()8.3
hope this helps you.
Type the number format like below
Hi Amit,
Why don't you use
=if(Sum(Sales)<0,'('&Sum(Sales)&')',Sum(Sales)).
Cheers,
Naresh
Thanks Alan it worked fine .
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