Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Use fabs() function.
Regards
ASHFAQ
Hi,
Use Fabs() like below
Fabs(Sum(Sales))
Hope this helps you.
Regards,
Jagan.
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 "-"
Fabs(YourExpression)
Then try something like this
If(Sum(Sales)>0,Sum(Sales)
Regards
ASHFAQ
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..
The colour of my bars have now disappeared and the scale at the bottom is still showing negative numbers
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,"-")