CalcFormula with an OR Expression?

Holly

I have a Flowfield which sums all records where

(Document No.=FIELD(No.) AND
Invoice = ''

I also need to sum where another condition is met. It would be something like
Where (Document No.)=Field(No.) AND ((Invoice = '') OR (BillByPiece = True))

Is this possible in a CalcFormula? I can't seem to make it work.

Thanks in advance.

Belias

i think that your only option is to create and evaluate a new boolean field in the "detail" table.
This field will evaluate like this:

mynewfield := ((Invoice = '') OR (BillByPiece = True));

after you've done this, you'll have to base condition your calcformula on "mynewfield".

Holly

Thank you for your quick reply. I'll give your suggestion a try.

Thanks again.