1 Reply Latest reply: Dec 21, 2017 8:20 PM by Yeo Poh sai RSS

    How to avoid select <6 Mth and not turn on Fast Moving ?

    Yeo Poh sai

      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