cancel
Showing results for 
Search instead for 
Did you mean: 

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

helen_jim
Participant
0 Kudos
168

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

View Entire Topic
kothandaraman_nagarajan
Active Contributor
0 Kudos

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
Participant
0 Kudos

Hi Nagarajan,

It woks. Thanks a lot for your help.

Best regards,

Helen