Report with negative values

[#1]

Hi guys,

There is a report with negative values,it should be displayed in brackets.

for eg. -5 it should be displayed as (5).

How to achieve it ?

Thanks.

[Anonymous]

HI,

You can define a number format for it....

num(field,'##,#0;(##,#0)')

So defining the format in brackets after ; defines for negative values

[krishnacbe]

Try below expression

=if(Value<0 , '(' & fabs(Value) & ')',1)

[Anonymous]

Defining If statement with concatenating () with value will result in string values instead of numeric,

while if using num() , then it will return in numeric values only...