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
JordanMcAlister's avatar
JordanMcAlister
Qrew Captain
6 years ago
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:


JordanMcAlister's avatar
JordanMcAlister
Qrew Captain
6 years ago
what does your gauge measure?