Skip to main content
Question

ToNumber function keep failing when using formula to create gauge chart

  • June 8, 2019
  • 0 replies
  • 53 views
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.
    • JonathanXu1
    • Author
    • Quickbase Alumni
    • June 10, 2019
    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