Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 24 at 02:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded