Originally Posted by: SO I have a bar chart with reversed signs and the value showing as labels. This works great.
The label look like this "100 -- 75%", so there is an extra - in addition to the "-" separator sign. If I turn off "reverse signs" it's presented like "-100 - 75%", so then the first value turns negative again and the percent turns positive.
My vertical bar chart is made from a crosstab showing amount posted on some finance accounts.
Okay, I have been able to replicate it then. The easy way to work around this problem, would be not to use the "reverse sign" function. Instead make a new calculation, and use one of the functions mentioned in the previous post.
In a simple table, you could simply do a new calculation looking like this:
sum(0,0,m1)*(-1)
or use (if and only if all numbers are negative):
abs(sum(0,0,m1))
Call this calculation the same as the original, and go to visibility in the properties menu to hide the original one. That should solve the problem.
However, I do agree that this is a minor bug. On the other hand - I would suggest other users to use custom calculations as often as possible. It is a good exercise, and it gives you the skills to find solutions to challenges, that are not "point-and-click" obtainable.
Please let me know, if this did not solve your problem.
Best regards,
Steffen