Division not working?

[Smote_Mote]

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

[Mohamed_Swella1 · Accepted solution]

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.

[Smote_Mote]

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!