How to filter the Training

[alvinford]

Hi All,

Trying to get the following logic. I have the following details in table

i.e. Teacher ID, Teaching Code, Status , Start Date and End Date.

I want to exclude the Teacher ID's who are in Training (teaching Code A16,A17,A18)  when the Year or

Month of Teaching period  falls in between the Start Date and End Date is selected.

For Example : If Year 2013 and Month 4 is selected, distinct count(Teacher ID) should be 4. i.e. Teacher ID 50440 and 54240 and 53080 to be excluded from the distinct count of Teacher ID as they are in the training.

For Example: If Year 2014 and Month 11 is selected , distinct count(Teacher ID) should be 6 i.e. Teacher ID 53080 will be excluded as from the distinct count as he is in Training for that selected period.

Would like to achieve this logic from the backend i.e. at Script

Please find the attachment for your reference.

Regards,

Alvin.

Message was edited by: alvinford ford

[petter]

Wouldn't also 53080 be "In training"? As row #3 claims so...

I am not sure that I understand your logic...Could you please explain more?

[petter]

This might be what you are looking for - but you don't need or probably would have a problem implementing this in a "Load Script". I have a solution that use the Set Expression and Excluded element function to achieve the logic that I think you are looking for:

[Kushal_Chawda]

what would be the Count of ID when date 4/1/2013 is selected?

[alvinford]

Hi Peter ,

You are right. 53080 will also be excluded when Year 2013 and Month 4 is selected.

As I mentioned earlier, would like to achieve this logic in the script.

Regards,

Alvin.

[alvinford]

Hi ,

Any help is aprreciated..

Regards,

Alvin.