Database create new Issues

So in my database I have Quantity under a number field has it should, now for example when I go to use it in Create New Invoice it says I can’t because it evaluates to text when it should a number, so I created a new state with it under number but does not input into the database and I need it as a number so I can do Rate * Quantity to get a total any help would be appreciated

does the info come from a user input or is it automatically generated?

Its through an Input the input the though is connected to a search box of a user created item