Condition for 6 consecutive time periods

[Former Member]

Hi All,

I have a query where I have to check whether 0sales KF is greater than a user entry value for 6 consecutive time periods (say weeks, months etc). I created 6 restricted KFs with variable offsets and created a single condition wherein I selected the condition variable. But when I execute the query, I get results where even if one of the months is not satifying the condition, I have results that are shown.

Now the second time I created six different conditions(for six different time periods) and executed the query. I am getting a meessage saying "No applicable data found".

Please help.

[Former Member · Accepted solution]

Hi Ashmit..

I have done this recently..It Works..

I had my 6 months Offset in a structure ..

then I created a condition and had 6 lines in them for every month..

Once you have this right..you need to make sure that your chracteristic identification is right..

Let me know..

Ashish..

[Former Member · Accepted solution]

Hi Ashish,

I was wondering if you meant have only one condition and include the value variable for all 6 months. Or create 6 conditions and activate them.

Thanks,

Ashmith Roy

[Former Member · Accepted solution]

I meant have ONLY ONE condition and include variable values for 6 months in them..

Ashish..

[Former Member · Accepted solution]

Hi Ashmit..

Just FYI..

As a thumb rule I always remember that different lines in ONE condition are a Logical OR ..

Having more than one condition is a logical AND ..

Hope you solve your problem..

Ashish..

[Former Member · Accepted solution]

Thanks Ashish,

I noticed the same thing.

Ashmith