Percentage Display Format

[rohitians]

Hello,

I have two colums where in I have sales comparison for two years,

I am have grwth % column,

Everythin is fine but want to show negative growth in following format  (20) format rather -20..

Thanks and Regards,

Rohit Yadav

[rohitians]

Hello,

I want to display -20 as (20)

[narender123]

Hi Rohit

if you have a column with -tive field then you have to multiply your expression with (-1)

or if have have only -20 single field that you want it 20 the set expression as

if(field='-20',20,field)

Thanks.

[#4]

try this function like this example

=fabs( -3.8 ) returns 3.8

example--

=fabs( -20 ) returns  20

[Sokkorn]

Hi,

Use Num() function will do this job.

=Num(-20,'#,##0;(#,##0)') ==> Return (20)

Now let give a try =Num(Field,'#,##0;(#,##0)') and let me know

Regards,

Sokkorn

[rohitians]

Hello ,

This is my current expression...

IF(Column(1)<0.001 OR Column(2)<0.001,NULL(),((Column(1)-column(2))/fabs(column(2)))*100)

The growth can either be positive or negative if its negative i wanna show -20 as (20)..

Thanks and Regards,

Rohit

[#7]

try this

=IF(Column(1)<0.001 OR Column(2)<0.001,NULL(),'(' & (fabs((Column(1)-column(2))/fabs(column(2))) *100) & ')')

[Sokkorn]

Hi Rohit,

This should work

IF(Column(1)<0.001 OR Column(2)<0.001,NULL(),Num(((Column(1)-column(2))/fabs(column(2)))*100,'#,##0;(#,##0)'))

Regards,

Sokkorn