Report Builder...Unit Price

Yahoo Archive
1
In the report, there are a couple of different places
to check. First, check the formula for the calculations.
This may have a rounding function being used. Second,
check the format of the number being displayed, it may
be set to only show 2 places. You can change that in the
format of that field. Double click on the field to get to the
format (I haven't actually seen this report, so these are just my best
guesses....)

Hope it helps.

Tim Care
Electro Chemical Finishing

----- Original Message -----
From: "George Brockman II" <gbrockman@...>
To: <vantage@egroups.com>
Sent: Tuesday, September 26, 2000 7:27 PM
Subject: [Vantage] Report Builder...Unit Price


> Kudos to whoever upload the sales backlog report to egroups. It saved me a
lot of time from writing one for the 'management' guys!
>
> I do need to make one modification that has me stumped. The value formula
for that report calculates the remaining open quantity and multiplies that
with unit price. The problem for us is that we sell gaskets, and many of
those can have prices that may be as little as .00001. The unit price that
is used in the calculation rounds up to hundreths. How can I change that?
>
> When you have an order for 12,000,000 parts and a price that is in the
'ten-thousandths' of a cent, the order value can be significantly skewed.
One of our owners is a CPA by trade, and inaccurate dollars makes me look
skewed!!
>
> George Brockman II
> Gasket Engineering
>
2
Kudos to whoever upload the sales backlog report to egroups. It saved me a lot of time from writing one for the 'management' guys!

I do need to make one modification that has me stumped. The value formula for that report calculates the remaining open quantity and multiplies that with unit price. The problem for us is that we sell gaskets, and many of those can have prices that may be as little as .00001. The unit price that is used in the calculation rounds up to hundreths. How can I change that?

When you have an order for 12,000,000 parts and a price that is in the 'ten-thousandths' of a cent, the order value can be significantly skewed. One of our owners is a CPA by trade, and inaccurate dollars makes me look skewed!!

George Brockman II
Gasket Engineering