I’m having a problem with a Crystal Report calculating order values. The report is exaggerating unit prices by 10x for every extra decimal place in the unit price of the item, as defined in the alternate price list item. So for an item that has 4 decimal places in it’s price, the Crystal Report will show a price of $1845.00 each, when it’s actually $18.4500.

Unfortunately I cannot just take the total order value / number of units ordered, as I’m interested in knowing the order value for orders that were already invoiced. When an invoice is closed the order value of course goes to $0.

Also, I tried doing an if formula that referenced the # of decimal places in the alternate price list item. This didn't work, as Crystal wouldn't let me link the Orders and Invoice database to the Alternate Price List database with the required info.

I know Adagio has issues with always assuming that the decimal place is 2 places away from the right. Is there a ‘turn off implied decimal place’ or something like that?

I was hoping there is someone out there that has solved this problem before.

Alternatively, it would work if I could find away to generate total original order value.

Thanks!