Jan 29, 2020 07:07 AM
Hello! I checked around but didn’t seem to find a good answer to why I am getting this error. I am looking to get a price per gram amount for my table. It should be Price/Grams but for some reason it gives me an error. I have included a screenshot below on imgur with everything spaced out since I can not attach images to my post and I can’t add links which is all very unhelpful. :expressionless:
imgur . com /a/Iqe597V
Solved! Go to Solution.
Jan 29, 2020 10:04 AM
Hi,
The reason is that both fields are defined as Text not as Numbers or Currency. Change the Price field to Currency and the Gram field to Number and it will work.
Jan 29, 2020 10:04 AM
Hi,
The reason is that both fields are defined as Text not as Numbers or Currency. Change the Price field to Currency and the Gram field to Number and it will work.
Jan 29, 2020 06:36 PM
Thank you! That resolved it perfectly! I keep forgetting that I need to format the type of columns to match the content. I appreciate your help!