Problem with Decimals - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Problem with Decimals

Message

From

21/08/2004 13:48:56

21/08/2004 12:27:53

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Miscellaneous

Thread ID:

00935202

Message ID:

00935207

Views:

Hi,

Sum(invitempost.qtyord * invitempost.unitpr) As [Ext_Price]

Try either

Sum(ROUND(invitempost.qtyord * invitempost.unitpr,2)) As [Ext_Price]

ROUND(Sum(invitempost.qtyord * invitempost.unitpr),2) As [Ext_Price]

Whichever is more appropriate...
Regards,
Viv