Different behaviour between gauge chart and text object

[#1]

Hi,
We have a gauge chart and text object operating with the same formula. The text object always shows the correct information, whilst the gauge chart is erratic and doesn't always display the same value that is shown in the text object.
Has anyone come across this problem and have a solution to it?
TIA,
Lance

[rwunderlich]

Confirm that your gauge chart expression is an aggregation function, not just a field reference. Can you post the expression used in both objects?

-Rob

[#3]

Rob, thanks for you response. This is the code for both fields:

=

sum(if(DEPTNO=4,[TOTAL SCRAP LENGTH],[TOTAL SCRAP UNITS]))/
sum(IF(DEPTNO=4,[TOTAL SCRAP LENGTH],[TOTAL SCRAP UNITS]))+sum(IF(DEPTNO=4,[TOTAL GOOD LENGTH],[TOTAL GOOD UNITS])))

Lance

[rwunderlich]

Nothing is jumping out at me. Can you post the qvw (or some data) as well?

-Rob

[Anonymous · Accepted solution]

Lance,
I assume the answer is "no", just to make sure - are there any dimensions in the gauge chart?

[#6]

Michael hi,
Thank you very much! Yes, there was a dimension in the gauge chart which caused this problem.
All the best,
Lance

[#7]

Rob hi,
Thanks for your efforts to help out here. I had a dimension in the gauge chart which caused this problem.
Lance