Discussions

 View Only
  • 1.  ToNumber function keep failing when using formula to create gauge chart

    Posted 06-07-2019 20:23
    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!



  • 2.  RE: ToNumber function keep failing when using formula to create gauge chart

    Posted 06-07-2019 21:00
    Can you tell us what in the value of those two fields.


  • 3.  RE: ToNumber function keep failing when using formula to create gauge chart

    Posted 06-11-2019 15:40
    Checkbox1 has the field type as Checkbox. I used the ToNumber function to get the total count in my table for how many rows have the checkbox1 being checked. Same for the Checkbox2. 

    I was able to use get ToNumber([Submit Pass Due])=30 and ToNumber([Submitted])=42. Both numbers were verified to be shown correctly. But once I put these 2 into division, it is keep showing the numerator only instead of 0.714....
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1792920/RackMultipart20190611-109042-1udh9u-formula_inline.jpg?1560267407">">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1792921/RackMultipart20190611-21645-akhpod-kpi_inline.jpg?1560267456">


  • 4.  RE: ToNumber function keep failing when using formula to create gauge chart

    Posted 06-10-2019 12:39
    Checkbox1 has total count as 30 and the checkbox2 has total count as 42. Thank you!


  • 5.  RE: ToNumber function keep failing when using formula to create gauge chart

    Posted 06-10-2019 15:33
    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:




  • 6.  RE: ToNumber function keep failing when using formula to create gauge chart

    Posted 06-11-2019 15:44
    Hi Jordan, both checkbox# fields have the type as Checkbox. I used ToNumber function to get the total count of how many rows have the checkboxes checked. I was able to get the chart show the ToNumber result correctly on individual ToNumber. But when I put both into division, the chart only shows the numerator instead of 0.714...


  • 7.  RE: ToNumber function keep failing when using formula to create gauge chart

    Posted 06-11-2019 17:02
    what does your gauge measure?