How can obtain the number of active store to date ?

[#1]

Hi all,

I want to count le number of active store and inactive store in the time.

active store : CSTATE >= 4 and CSTATE < 7 thus CSTATE={4;5;6}

inactive store : CSTATE >= 4 and CSTATE >= 7 thus CSTATE={4;5;6,7}

The problem is that store can be active at the beginning of month and inactive at the end of month.

I just want the real active store to date.

Thanks for your help.

[jonathandienst]

Your post is a little confusing. So if CSTATE = 4 is the store active or inactive?

Your document is too large, see here: Preparing examples for Upload - Reduction and Data Scrambling

[#3]

STORE active is CSTATE contains 4,5,6

STORE inactive is CSTATE begin by 4 and left by 7

example:

llifecycle store : 12456 = ACTIVE (because contains 4)

llifecycle store : 124 = ACTIVE (because contains 4)

llifecycle store : 124567 = INACTIVE (because contain 4 and 7)

llifecycle store : 12 = READY TO START

[#4]

Thanks Jonathan for this tips.

In attachment the file reduced.

[#5]

Hi

Someone can help me please?