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