Skip to main content
Question

ToNumber function keep failing when using formula to create gauge chart

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!

    This topic has been closed for replies.

    Can you tell us what in the value of those two fields.
    Checkbox1 has total count as 30 and the checkbox2 has total count as 42. Thank you!
    Have you tried to use just a formula-numeric field? Also, have you confirmed in the formula field that the ToNumber of your checkbox# fields equal 30 and 42? What are the field types of the checkbox fields?

    I tested this scenario myself and am getting correct results using a formula-numeric field:


     Result:


    Terms & ConditionsAccessibility statement