Skip to Content
Former Member
Nov 13, 2008 at 03:45 PM

Boolean Formula - Aggregation



I'd like to create a formula that depends on two dates as the following:

(REQ_DATE <= CONF_DATE) * (Order_Qty - Confirmed_Qty) +

(REQ_DATE > CONF_DATE) * (Order_Qty)

For that, correct me if I'm wrong, I absolutely need to define two variables for my dates characteristics? (That's what I did but just want to make sure I'm not taking too much steps).

Now, I don't really care about displaying these two dates on my report but it seems that I need them, otherwise I see a "X" in the calculation. As soon as I add the two dates then I see the result.

The thing is that I want my report more at a Material aggregated level and not interested in the details per orders; am I asking too much or is it simply something I'm forgetting?

So, what I'm looking for is a result such as

Material #          Quantity
AFK-01               500.000
AFJ-04               400.000
SDF-02                20.000

But by having the dates, I'm more having such as:

Material #     Req. Date    Conf.Date   Quantity
AFK-01        2008.01.01   2008.01.05   100.000
AFK-01        2008.02.05   2008.02.06   200.000
AFK-01        2008.10.01   2008.10.05    50.000
AFK-01        2008.01.08   2008.01.12   150.000
AFJ-04  ....

Thanks for any help.



Edited by: John Den on Nov 13, 2008 1:32 PM