I am kinda new to database design. Current design was working perfect until I found an issue.

Is a financial APP that recieve a lot of data.

There are mainly 2 data types:

Auto calculated where precision will be between 0% and 100% with 2 decimals, in few cases can be little more than 100%, so I set Numeric(6,2)

The other situation is raw data to calculate all those metrics. With big stocks I was ok with smallint/integer, because numbers are big and can be always integers (numbers like 257637, 188143) taking into account I save them in Millions. Problem is that, since I use millions unit, I realised that when I storage some small stocks those values can go as low as 0.10, so what should I do in this situation, go to Numeric(10,2) or so in all columns? Or there is another better way.

Thanks in advance.