Troubles If some referenced fields are empty

[alin]

Hi everybody,

I am developing a DB for invoicing. In the invoice line I have the following fields:

Description | UnitPrice | Coefficient1 | Coefficient2 | LineTotal

LineTotal = UnitPrice * Coefficient1 * Coefficient2

An example could be

[alin]

I got it myself. So, there is no need for an answer, or maybe, another way of solving it?

My solution looks like that:

LineTotal=

Case(

IsEmpty(coef1) and IsEmpty(coef2), coef3,

IsEmpty(coef1) and IsEmpty(coef3), coef2,

IsEmpty(coef2) and IsEmpty(coef3), coef1,

IsEmpty(coef1) , coef2*coef3,

IsEmpty(coef2), coef1*coef3,

IsEmpty(coef3), coef1*coef2,

coef1*coef2*coef3)

Thank you anyway

Alin