I have 3 columns in the table:

Net_Weight Integer
Net_Income Decimal 2 decimals
Net_Income_Per_Kg   Float

Net_Income_Per_Kg computed with:
"Net_Income_Per_Kg" FLOAT COMPUTED ALWAYS AS Net_Income / Net_Weight

Even though Net_Income_Per_Kg is a Float, it stores only 2 decimals, probably because the greatest # of decimals in the computation (Net_Income) has only 2 decimals.

Is there a way to force Net_Income_Per_Kg to store 3 decimal places?

TIA
Barry

Barry,

It's because the expression (Net_Income / Net_Weight) is of type DECIMAL(19,2), as Net_Income is a DECIMAL, and Net_Weight is INTEGER - only after the computation the result is converted to FLOAT.

You can force force it to be of type DECIMAL(19,3):
"Net_Income_Per_Kg" FLOAT COMPUTED ALWAYS AS CAST(Net_Income AS DECIMAL(19,3)) / Net_Weight

or even FLOAT:

"Net_Income_Per_Kg" FLOAT COMPUTED ALWAYS AS CAST(Net_Income AS FLOAT) / Net_Weight


--
Fernando Dias
[Team Elevate]

Fernando,

That worked, thanks.

Barry