Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All
my gauge chart ve display 2 set of data :-
Case 1
100 increase to 110 as +10 % increase
Case 2
-100 increase to -110 as +10 % increase
How to make it for case 1 display in green zone . For case 2 display in red zone ? ( Since case 2 is lost money )
Now both display in Green zone. Which is wrong.
Paul
Hi,
Check the attachments,
Is that what you desired. !
Please post example data/app.
Regards
Marco
100 to 110
=(110-100)/100
= 10/100
=10%
-110 to -100
=(-100-(-110))/(-110)
=(-100+110)/(-110)
=10/(-110)
=-9%
Let me know if I am wrong !
Hi manish
Yes you are correct.
It is possible to add condition in expression ,in case both value are -ve then compute result will be set -ve.
Paul
Sent from my iPhone
like this?
100 increase to 110 as +10 % increase
fabs(110-100) / 100 --> 10%
(110-100) / fabs(100) --> 10%
-100 increase to -110 as +10 % increase
I'm not sure in this case you have a +10%. May be a -10%?
I think the sign should be the abs of numerator denominator
fabs((-110)-(-100)) / (-100) --> -10%
((-110)-(-100)) / fabs(-100) --> -10%
Hi All
Thank you for your sharing,
Enclosed my QV Doc.
Paul !
Hi All
Many thank , it is possible to apply your answer into my QV doc ?
As i have try both solution with file attachment , i cannot figure out how to apply.
Paul