Forum Discussion

JonathanXu1's avatar
JonathanXu1
Qrew Trainee
5 years ago

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([check...
Formulas and functions
reports and charts
JordanMcAlister's avatar
JordanMcAlister
Qrew Captain
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:


JonathanXu1's avatar
JonathanXu1
Qrew Trainee
5 years ago
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...