Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
try
use Fabs function
Fabs(urexpression)
EX:
If(fabs(sum(sales)=0,Value)
Hi,
you can set the format like :
=num(sum(test),'#,##0.0;(#,##0.0)')
HTH
Sushil
Do I have to write it in the text format of the expression , or it`s in the expression itself?
Just use Fabs(Fieldname) as script, it will treat all -ve values as +ve values
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.
Thank Anil , that worked.