I am trying to create a gauge chart by using formula-numeric-percent. The formula is based on the division of 2 ToNumber functions. The result is an irrelevant integer.

In my case, ToNumber([checkbox1]) =30 and ToNumber([checkbox2]) = 42

when I enter following into QB formula, the return is still 30 instead of 0.71

ToNumber([checkbox1])/ToNumber([checkbox2])

I have 0 backgrounds on programming. Really need help here.

Thank you!