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!