Skip to Content
0
Former Member
Nov 14, 2005 at 04:26 PM

Condition for 6 consecutive time periods

16 Views

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.