Help

Division not working?

Solved
Jump to Solution
373 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!