How to change -0 to 0 in a combo chart?

[Anonymous]

Hi,

Can someone please help me in changing -0% to 0% in a combo chart.

Am able to do it in the straight table but the same expression is not working in the combo chart.

Thanks!

[buzzy996]

use thins function , fabs()

[Anonymous]

But the fabs function changes all other -ve values to +ve right?

I want just the -0 to 0

[ramoncova06]

can you round the numbers ?

there is no such thing as a negative 0, so this is most likely because of decimals, so you might be able to apply a round function to get rid of it

[buzzy996]

But the fabs function changes all other -ve values to +ve right? --yes.

I don't think so tht's possible,else u have to use text object to show in graph

[Anonymous]

when I round the numbers  am loosing the % values completely.. 😕

[anlonghi2]

Hello ChinnuKool,

try with this:

if(YOURVALUE<0 and left(YOURVALUE,6)='-0.000',0,YOURVALUE)

Best regards

[ramoncova06]

what kind of aggregation are you using in you expression ?

[Anonymous]

if(YOURVALUE<0 and left(YOURVALUE,6)='-0.000',0,YOURVALUE)

The ablove if statement didnot work in the combo chart, it did work in the straight table.

Am doing SUM to get my values and i see -0%.

Is it possible to  fix this in a combo chart?

[Anonymous]

Don't round to integers like this round(Field).

Round to 1/100: round(Field, 0.01)