cancel
Showing results for 
Search instead for 
Did you mean: 

Boolean Formula - Aggregation

Former Member
0 Kudos

Hello.

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.

Regards,

John.

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Solved it by putting the calculation directly within the Info Cube as it does not seems possible to achieve in the Query.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi John,

I think u are getting X in that scenario because for ur calculation it is unable to pick up any particluar date as it is different for different records,

Regards,

Rathy