Showing negative as a positive

[#1]

I am trying to show values in my X axis as positive figures - I only want these figures to "appear" positive and not actually be positive.

Please see below:

[ashfaq_haseeb]

Use fabs() function.

Regards

ASHFAQ

[jagan]

Hi,

Use Fabs() like below

Fabs(Sum(Sales))

Hope this helps you.

Regards,

Jagan.

[#4]

using fabs gives me the below graph.... I want the negatives to still be negative, just appear as though they aren't - just need to get rid of the "-"

[MK_QSL]

Fabs(YourExpression)

[ashfaq_haseeb]

Then try something like this

If(Sum(Sales)>0,Sum(Sales)

Regards

ASHFAQ

[MK_QSL]

Go to Expression Tab

Click + on your expression

Go to Bar Offset

Add whatever is the Min Value of your Expression

in your case it looks like -5... so write 5 in bar offset..

[#8]

The colour of my bars have now disappeared and the scale at the bottom is still showing negative numbers

[#9]

this will give me positive numbers - I need the negative numbers to be negative but not show the "-"

In excel I would use custom formatting and say (#,##0;#,##0,"-")