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
Best answer by Mohamed_Swella1
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.
+17Hi,
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.
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.
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.