[DataLens On-premises] ROUND with precision parameter is not supported for double precision data type in PostgreSQL

ERR.DS_API.DB.INVALID_FUNCTION.PG_DOUBLE_PRECISION_ROUND

The ROUND function with the precision parameter is not supported for the double precision type of PostgreSQL data source.

DataLens recognizes PostgreSQL's double precision and numeric types as a Fractional number. Out of these two types, the ROUND function with the precision parameter only supports numeric. To get double precision back to the database level, use another function: DB_CAST.

Here is an example:

ROUND(DB_CAST([your field]/1000000, 'numeric', 16, 8) [, precision ]), where 16 is the total number of digits in the fractional number, and 8 is its count of decimal places.