Forum Discussion
sanc_152
Helper I
Helper ISequence 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
Ahmedx
Super User
Super Userpls try this
sanc_152Helper I
Helper Ihi 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
pls try again this