'Text in chart' error on a gauge

[#1]

Hi all

I can't seem to figure out why this isn't working.  I've created a gauge.  The needle point to the correct figure and if you hover over the text I've added to show the numerical %, then it hovers the correct figure - but the actual text displayed keeps coming up as 100% (which is wrong).

='% satisfied: '&Num(Count(Q2_S_OverSatComp) / Count(TOTAL [Q2_V_OverSatComp]),'##.#%')

Can anyone see an error in this expression?  Or is it a setting somewhere that needs updating?

Thanks in advance.

Alex

[ngulliver]

Hi, Alex.

I would recommend breaking the equation into chunks if you haven't done so already. Create a text object for each side of the equation to check the values in each.

One thing that strikes me from your sampe is that you are counting Q2_S_OverSatComp against Q2_V_OverSatComp

Is that correct ?

Hopefully that helps. Otherwise you may need to put a bit more information about the fields for anyone else to properly diagnose the issue.

Neil.