Query result is rounding up to whole units without displaying decimal places

[helen_jim]

Dear Experts,

The query result generated in the Query Generator is currently rounding up to whole units without displaying decimal places in SAP B1 on SQL. I am seeking guidance on how to configure the MAX statement in the query to display the original value with 4 decimal places.

Here is query:

MAX(CASE WHEN T0.[RateDate] BETWEEN '2023-04-01' AND '2023-04-30' THEN CAST(T0.[Rate] END) AS "01/04/23 to 30/04/23"

Your advice would be greatly appreciated.

Best regards,

Helen Jim

[kothandaraman_nagarajan]

Hi,

Try this query,

MAX(CASE WHEN T0.[RateDate] BETWEEN '2023-04-01' AND '2023-04-30' THEN T0.[Rate] END) AS "01/04/23 to 30/04/23"

Regards,

Nagarajan

[helen_jim]

Hi Nagarajan,

It woks. Thanks a lot for your help.

Best regards,

Helen

[farooqahmad]

Go to Administration,

System intilization,

General setting

Display

Increase decimal places in query

Increase the size

[helen_jim]

Hi Farooq,

Decimal places in query is set to 2 and there is no issue with selecting the fields from the ORTT table. The problem is specific to display the numeric value with MAX statement .

Best regards,

Helen Jim