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).
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.