Good morning!
I’m using a button to set a “Price” from three options.
The table is looking up the three fees from a lookup where the field is a number field, however, it enters a number replacing the comma with a decimal point. (As you can see. 13.5 instead of 13500) I can’t figure out how to get it to show the actual number. Any ideas?
Here’s the table:
What am I missing? Thanks in advance for your help.
It looks like you are using a Join List column instead of Look Up column. Could you please double click on one of your fee columns and send us the screenshot?
Hi Hassan,
Thanks for your help. I also tried a lookup and got the same result.
I changed it to a join to see if it made any difference.
Andrew
Try removing the comma from the Separated By on the configuration screen of Join List column?
Good idea. I tried that… still the same result.
Andrew
I’m sure we are missing something here. Trying adding a math column on this table and just write “In Person High”. See what value it is giving you? Is it giving you 13.5 or 13,500?
Let me try that! BRB.
Stick with a Lookup. Don’t use a Joined List for this.
Try removing the dollar symbol and possibly the thousand separator (comma) from the column you are trying to look up. Or create a separate basic number column in the table you are getting those numbers from with just a number and nothing else, and then lookup that column. Better to work with just numbers instead of numbers intermixed with text characters.
It’s trying to convert text into numeric values and I think the extra characters are throwing it off, or causing to treat the comma as a decimal, which is valid in certain countries.
A single look up column won’t work in this case I believe as @mondrew is using a Query Column.
Doing a look up on query will bring the result in an array.
@mondrew, try doing a look up and then use single value column to extract the number.
Good catch. You can directly use a Single Value column against a query. No need for an intermediate Lookup.
I’ll try that tomorrow morning awesome
Jeff,
That works!! A Single Value Column works great!!! It displays correctly and enters the correct value.
Thank you!
Andrew
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
