 Rank: Advanced Member
Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 109
|
I have built a speedometer gauge showing sales vs budget. My original sales and budget amounts are negative since I get my data from finance accounts. In my crosstab I use "reverse signs" to show the values as positive values, this works great in my reports for crosstabs and charts.
So far so good.
Then I created a gauge of the crosstab, but the gauge shows negative values. So it looks quite strange having the gauge moving the wrong way (to the left) towards bigger and bigger negative numbers.
How can the gauge be set to reverse signs?
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 109
|
I solved this with creating a new calculated column where I multiplied my amount with -1, not an elegant way to solve it but at least it works.
Is there any other way to solve it?
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 505
|
Your solution of creating a calculated column, multiplied by -1, is probably the best solution - if not the only solution.
BR / Ole |
Ole Dyring |
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.