Skip to Content
author's profile photo Former Member
Former Member

Boolean Formula - Aggregation

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

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2008 at 04:55 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 04:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded