Hi All
I have expression below from Anil. it work fine . But due to <6 Mth and Fast moving product both are link.
'=
if(L_issue = '00/00/0000' AND L_move <> '00/00/0000', ('New Product'),
if(S1 > '0' AND S2 > '0' and S3 > '0', ('Fast Moving'),
If([No of Months_] >= 1 and [No of Months_] <= 6, Dual('<6 Mth', 1),
If([No of Months_] >= 7 and [No of Months_] <= 12, Dual('>6 Mth-1 Yr', 2),
If([No of Months_] >= 13 and [No of Months_] <= 36, Dual('>2-3 Yr', 3),
If([No of Months_] >= 37 and [No of Months_] <= 60, Dual('>3-4 Yr', 4),
If([No of Months_] >= 61 and [No of Months_] <= 84, Dual('>4-5 Yr', 6),
If([No of Months_] >= 85 , Dual('>5 Yr', 7),
))))))))
Because when items for keep selling for last 3 month i classify it as fast moving , and for stock less then 6 month in ware house , which may consider as fast moving.
So my question is , when i select <6 Mth , i like to know how to exclude those fast moving items.
The script should be look some thing like below , but it cannot work :-
if(L_issue = '00/00/0000' AND L_move <> '00/00/0000', ('New Product'),
if(S1 > '0' AND S2 > '0' and S3 > '0', ('Fast Moving'),
If([No of Months_] >= 1 and [No of Months_] <= 6 and S1 |> '0' AND S2 |> '0' and S3 |> '0', Dual('<6 Mth', 1),
If([No of Months_] >= 7 and [No of Months_] <= 12, Dual('>6 Mth-1 Yr', 2),
If([No of Months_] >= 13 and [No of Months_] <= 36, Dual('>2-3 Yr', 3),
If([No of Months_] >= 37 and [No of Months_] <= 60, Dual('>3-4 Yr', 4),
If([No of Months_] >= 61 and [No of Months_] <= 84, Dual('>4-5 Yr', 6),
If([No of Months_] >= 85 , Dual('>5 Yr', 7),
))))))))
Hope some one can advise me.
Paul Yeo
