en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
SO  
#1 Posted : Wednesday, September 2, 2015 11:10:17 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 88

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?
SO  
#2 Posted : Thursday, September 3, 2015 5:58:18 AM(UTC)
SO
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 88

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?
Ole  
#3 Posted : Friday, September 4, 2015 8:13:26 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 324

Your solution of creating a calculated column, multiplied by -1, is probably the best solution - if not the only solution.

BR / Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Users browsing this topic
Anonymous
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.

Notification

Icon
Error