Modify display value when sum<0

[razvan_brais]

Hey guys. Me again. How can I modify the display of a value that is lower then 0;

I want that if the result is <0 to display it like this (value).

So if value is -150 to display (150)

[Chanty4u]

try

use Fabs function

Fabs(urexpression)

EX:

If(fabs(sum(sales)=0,Value)

[sushil353]

Hi,

you can set the format like :

=num(sum(test),'#,##0.0;(#,##0.0)')

HTH

Sushil

[razvan_brais]

Do I have to write it in the text format of the expression , or it`s in the expression itself?

[Anonymous]

Just use Fabs(Fieldname) as script, it will treat all -ve values as +ve values

[Anil_Babu_Samineni · Accepted solution]

Where you want to show this. I mean which object. If text object might be my solution is not work left all will work

Tri properties and them number tab choose

#.000; (#.000)

This format will give all positive number.

[razvan_brais]

Thank Anil , that worked.