Staff turnover with Set Analysis

[#1]

Hi everybody,

I’m working on a datebase with a field called « Month » (format ‘MMM-YY’).

Each month, I add the company personnel list relative to said month.

What I’d like to do is, by selecting one month, display the staff “in” and the staff “out” compared to the previous month.
I’m wondering if I have to declare some variables in the script to use Set Analysis functions.

Thanks in advance for your help

[#2 · Accepted solution]

Hi Flalanne,

i attach a file posted for an old similar question.

In this example the field "pres" is set to 1 if the relativ cust is present in that month/year, 0 if not.

For example if in march pres is 0 and in april 1, the relative custmer is entered.

I hope it's useful.

Stefano

[#3]

Hi Flalanne,

this file is better... I use P() and E() function in set analysis.

In this way it's not necessary to have all record in the originary table.

C u,

Stefano.

[#4]

Perfect ! Exactly what I need. Thanks

[#5]

Actually, it works perfectly for the staff entrances, but there is no result for the departures.

In your exemple, the value of pres2 field is 0 whereas the line is deleted in my application.

Any idea ?

Thanks.

Franck

[#6]

Hi Franck,

try if this is ok.

C u,

Stefano

[#7]

Thank you so much Stefano ! It works !