The precision of the decimal value is larger than the target precision

[former_member234353]

Hello All,

I have a column datatype-d as decimal (18,2). All the data for that field has been successfully inserted for the field.

But when I do an aggregation on this field, specifically, sum then it throws me an error.

[314]: numeric overflow: the precision of the decimal value is larger than the target precision: 18 at function __copy_trex_field_Fixed8_check__() (at pos 7) .

Can you please tell me what have I done wrong to get this issue.

Thanks,

AJ

[SergioG_TX · Accepted solution]

it looks like the aggregation column does not have the correct data type - you should use the max data type for the aggregated columns - make also sure if you have a calculated field to sync their data type