cost price * quantity in stock

unknown

Greetings All,

No doubt this'll be easy for you!

We have a customer who's Std. Cost price is in 4 decimal places.

I've written a Reporter report and added in a formula which multiplies the Std.Cost price by the Quantity in stock. However I don't know how to get the formatting correct so it show up to 4 decimal places.

E.g. 700 * 0.1568 = 109.76 but the report displays it as 1097600.0000 rather than 109.7600 which is what it should be.

Attached a screen print of field.

Any help much appreciated :-)

unknown

Use the standard stock valuation report they said, so I did!

Scrap the discussion!