Help

Division not working?

Solved
Jump to Solution
1341 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Smote_Mote
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

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.

See Solution in Thread

2 Replies 2
Mohamed_Swella1
13 - Mars
13 - Mars

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!