Forum Discussion
Solved
Sequence Calculations
Hi All, Need one help Product Customer Week Date Flag 1 A 1 01-01-2023 Y 1 A 2 08-01-2023 Y 1 A 3 16-01-2023 Y 1 B 1 01-01-2023 Y 1 B 2 08-01-2023 Y ...
pls try again this
hi Ahmedx
It is giving some differnt results
In below data for Product A having 2 customers 1,2 resp and if you see they both are
appeared in consecutive weeks (4,5,6) So my flag should assigned as Y, but the formula retunring different result.
for both customers the product is overlaped for parallel period 4,5,6 So it should be giving me flag As Y.
| PRODUCT | Customer | Week | Sequnce_ | Flag_test |
| A | 2 | 1 | 1 | N |
| A | 2 | 1 | 1 | N |
| A | 2 | 2 | 1 | N |
| A | 2 | 3 | 1 | N |
| A | 2 | 4 | 1 | N |
| A | 2 | 5 | 1 | N |
| A | 2 | 6 | 1 | N |
| A | 2 | 7 | 1 | N |
| A | 2 | 8 | 1 | N |
| A | 2 | 9 | 1 | N |
| A | 2 | 10 | 1 | N |
| A | 2 | 11 | 1 | N |
| A | 1 | 4 | 4 | N |
| A | 1 | 5 | 4 | N |
| A | 1 | 6 | 4 | N |
| A | 1 | 7 | 4 | N |
| A | 1 | 8 | 4 | N |
| A | 1 | 12 | 4 | N |
| A | 1 | 13 | 4 | N |
| A | 1 | 14 | 4 | N |
Ahmedx
Super User
Super Userpls try again this