calculation of item squaremeters in an invoice for price calculation
hi to all,
we have got a customer who build wooden boxes.
he likes to calculate the price of the box in squaremeters of the surface.
the measures of the box are in the sales data (lenght,width..)
i only like to know , if somebody got an idea of an sql statement wich calculate the squaremeters and write the result in a UDF.
thanks to all readers