Forum Discussion

JonathanXu1's avatar
JonathanXu1
Qrew Trainee
6 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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Can you tell us what in the value of those two fields.
JonathanXu1's avatar
JonathanXu1
Qrew Trainee
6 years ago
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....