Calculated Column identify cases between two dates

[nicolasvargas]

Hello,

I have a database with the following structure:

ID	In Point	Out Point	Desired Column
A	0	0	0
A	1	0	1
A	0	0	1
A	0	1	1
A	0	0	0
B	1	0	1
B	0	1	1
B	0	0	0
B	1	0	1
B	0	1	1

I have on data base the entry point (IN POINT) since which I would like to filter a specific ID and an exit point (OUT POINT). I would like to have a Calculated Column that returns 1 for every time it is activated between the in/out points.

It seems easy but I cannot manage to make it work. I would appreciate your help

[MattAllington]

I don't see any pattern. Row 3 is 0,0,1. Row 5 is 0,0,0