How to set decimal digits in query？

[Joanna]

Hello, Experts,

I create a Query based on the basic cds view, then I find the decimal digits is incorrect,

How to set decimal digits to 3?

RGDS

Joanna Qiu

[JZijderveld · Accepted solution]

Hi Joanna,

In one of my queries I can set it to 2 decimal digits but when I change to 3 digits it removes the digits all together. I checked the datatype QUAN in an OnPrem system and it is defined with 3 decimals there.

Strange.

rgds

Jeroen

btw: Can someone remove or mark the Edmin answers as irrelevant?

[Sandeep_Kumar · Accepted solution]

jjzijderveld2019 Edmin was not correct in this case, removed the response. Thanks.