How can change the Negative value to Positive value. I understand that we can use the Fabs Function but I don't want to use that in my situation. If you look at the attached image... you will understand why I can't use the Fabs Function. I need to show the bars on to the left hand side to show full analysis of the chart. I am looking for something in Formatting tab. All I want to do is remove the "-" Minus sign before the value on the left side. Please can someone help on this?
Can you format the value as a string using the function PurgeChar() where you could remove the '-' character as part of a string value? This might not change the calculation and interfere with the correct presetnation of the report.