How to set field type as float/decimal?

I'm getting an error ERROR: invalid input syntax for integer: "0.384".

Upon inspection, i found this is for a field that is unwrapped from a json field.
Now, i would like to set the type of this field as float or decimal, but i don't see any such option anywhere.

How do i resolve this?

Note: every time i try to resync the database schema or re-scan the field values, the operation results in the same error as mentioned above.

Go to settings->admin->data model-> search for the column and check the data type

I did find the column in the settings. The issue is, i couldn't find any option for Field Type for Float/Decimal.

Set it as a currency or no semantic type