Skip to Content
0
Former Member
May 29, 2008 at 09:58 AM

Decimal and formatted search

108 Views

hello,

I've defined an UDF as Price.

Number of decimal for prices is set to 3 in the general settings.

the actual result of my formatted search is rounded to 2 decimals although 3 decimal are displayed.

here is a simple formatted search that illustrate the issue :

SELECT 100 / (100+19.6)

the displayed result is 0.840 instead of the correct value : 0.836

How can It be solved ?

Best regards,

Francis