Workdate in a Flowfield

Waldo

I would want to create a flowfield (in the item table), which is a total of a quantity in a certain table. The table looks as follows:

DOCNO    ITEM       DATE       QTY
--------------------------------------
SH001     X       16/01/03     12
SH001     X       17/01/03     12
SH001     X       18/01/03     12
SH002     X       17/01/03     23

It means that 12 pieces of article X is three days away (16, 17 and 18th of january), and for another document 23 pieces of article X is away for 1 day (17th).

Suppose that my WORKDATE is 17/01/03, how do I create a flowfield to calculate the total quantity of X that is away (in this case: 12 + 23 = 35)?

Thanks for any response!

Luc_VanDyck

You can't have variables in the calcformula of a flowfield.

Nick

...but you can have FlowFilters. If you have a "Date Filter" field on the table you can use this in your FlowField calculation. You could set the Date Filter automatically on a report (or form) to be the workdate.