Expression returns different result when used in Gauge Chart expression and when concatenated with Text in Chart

[taha_mansoor]

Hi,

I am simply showing up the production ratio with sale using a gauge chart. The expression is Sum(Production)/Sum(Sale). I am using the same expression in 'Text  in Chart' as well to show the numeric figure beside the chart needle. The problem is that the expression result is different in gauge chart and in Text. In gauge, it shows 23% but in text it shows 19.36%. I can't understand why is this happening. The expression is same on both places but result is different.

Screen shot of my gauge chart is attached.

Regards,

Taha

[taha_mansoor]

christianj‌ Yes I did match all the configuration for your gauge chart in your qvw with my gauge chart in my qvw but result is same in my qvw. Basically, I got the clue where actually the problem is. The text in chart returning the correct figure. The needle is showing the incorrect figure in gauge, however, the expression used on both the places are exactly same. Now it needs to be find out why needle is pointing the incorrect figure.

Taha

[taha_mansoor]

@Adam Krepistman: Yes I tried the way you told and its returning the mismatched figure and that figure is as same as the text in chart expression one. Well, I have got the clue here. The text in chart returning the correct figure. The needle is showing the incorrect figure in gauge, however, the expression used on both the places are exactly same. Now it needs to be find out why needle is pointing the incorrect figure.

Taha

[Marcio_Campestrini]

Hi

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.