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
if(Sum(exp)<0, '()'&fabs(sum(exp)), sum(exp))
Thanks Alan it worked fine .
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
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)', '.', ',')
try to use fabs() function
='()' & fabs(-8.3)
then output is
hope this helps you.
Type the number format like below
Why don't you use
Retrieving data ...