Chart - show negative value positive

[#1]

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 ?

     Thanks for your help.

[rajni_batra]

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

[MayilVahanan]

Hi

Try like this

fabs() which converts negative to positive number

[CELAMBARASAN · Accepted solution]

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

#,###;#,###

[#5]

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.

[rajni_batra]

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,

[#7]

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,