Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thanks Jonathan for this tips.
In attachment the file reduced.
Hi
Someone can help me please?