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
pls try 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 pls try again this
