I’m trying to create a drop down component where several choices are numbers, but I need the last choice to be “other.” So I can’t put my choices in a number column. But I need the other choices to be numbers, not text, because I’m using them in a formula.
Ideally, I’d like “other” to be entered as a zero to make my formulas work, but I have no idea how to accomplish that.
Create a column to store your “front-end” choices. This would be 1, 2, 3, 4, Other.
Create a column to store your “back-end” choices. This would be an if-then-else column. If front-end choice is “Other”, then 0, else just return the same front-end choice.
In your choice component, point “Values” field to back-end choices, “Dispaly as” field to front-end choices.
When I choose any of the numerical options, it works perfectly. But when I choose “Other” it doesn’t write the zero for some reason I can’t figure out. I’ve tried drop downs and radio buttons as well… Same result. For some reason it’s not picking up the zero.
If you create a normal numeric column and manually fill in the numbers, does that new column work better than the IF column with your choice component?
Right, but what I’m saying is to replace the IF column with a basic column. You would still use the Display column for the ‘Display As’ parameter, but change the Value parameter to use the new column instead of the IF column. Just trying to determine if the IF column is the issue or not.
I get it. I made a test numeric column and pointed the value parameter to it and it works just fine. So it appears that the IF column is the issue, and I’m trying to figure out a workaround so I can still include OTHER as one of my choices and when someone chooses OTHER the value becomes zero.
I suspect the problem is the IF column isn’t numeric?
This should be the case if you are setting the ‘Display As’ parameter.
in the choice component. If not, it would help to see a screenshot of you choice component configuration.
Possibly, even though I’m really surprised that it wouldn’t work.. Actually the problem may be because the ‘Bike Value’ column is not numeric, which means the IF column not numeric. But usually, stuff like it’s pretty flexible as far as working with different data types. I guess you could use the IF column, then follow it with a math column to get the value to become numeric.