6 Replies Latest reply: Oct 18, 2013 9:22 AM by Nicolas Bevernage

# Chart - show negative value positive

Hey,

On the first i hope you can excuse my english because it's not my maternal language and maybe my question. I search a lot on community without response.

I create an age pyramid on a single chart who make a difference between man and women. For show the differences I make a man's numbers negative. I would like in my chart show this value positive.

I already try different number format without success.

Do you have an idea, a solution ?

• ###### Re: Chart - show negative value positive

use fabs() function hope this could help u

from QV Help :

#### fabs( x )

The absolute value of x. The result
is a positive number.

## Examples:

fabs( 2.4 ) returns 2.4

fabs( -3.8 ) returns
3.8

Regards,

Rajni

• ###### Re: Chart - show negative value positive

Hi

Try like this

fabs() which converts negative to positive number

• ###### Re: Chart - show negative value positive

You could change it in Number formatting tab.For both positive and negative as same

#,###;#,###

###### Celambarasan thanks for you answer that's work perfectly.

For they other answer, if you use fabs() in your expression that's convert value before to show them and i would like only visualy.

Thanks a lot everybody.

• ###### Re: Chart - show negative value positive

no but fabs() can be used outside complete expression this is also for visual purpose.

you can use it like

fabs(sum(A)/Sum(B))... it will change - to + only after calculation of expression.

Regards,

• ###### Re: Chart - show negative value positive

Rajni,

I try on a graph to use it without sucess. It's transform value in positive value. My purpose, it's negative value stay a negative value but visually you saw a positive value.

Thanks,