Money attributes being rounded to nearest whole number

MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool

MIT License

75 stars 22 forks source link

Money attributes being rounded to nearest whole number #589

Open crusselllike10 opened 3 days ago

crusselllike10 commented 3 days ago

Attributes of type money are being rounded to the nearest whole number in query results.

I am using the latest version 9.4.1

MarkMpn commented 2 days ago

I can't reproduce this:

Is there any more information you can give about your query, data and/or environment that might help?

crusselllike10 commented 1 day ago

Sorry, I forget to mention I am using Azure Data Studio 1.50.0.

If I connect directly to the TDS endpoint in ADS and query the revenue attribute from account it shows fractional values, but when I do the same query with Sql4Cds they are rounded.