11 Replies Latest reply on Nov 9, 2016 4:34 AM by Kishan_Canoo

    ‘Item Movement’ (e.g. Best-seller, Fast, slow)

    Kishan_Canoo

      In an existing solution one of my client my client has requested to add a field name ‘Item Movement(e.g. Best-seller, Fast, slow) and this should be based on a formula per product item and linked to 'Stock re-order level’ field.

      For example, if product A reaches ‘Stock re-order level’ in less than one month, it is categorized as ‘Best Seller'’. If Product A reaches ‘Stock re-order level’ in 2 months, it is categorized as ‘Fast’. If Product A reaches ‘Stock re-order level’ after more than 2 months, it is deemed ‘slow

      Since it’s depend on a date, I found it a bit complicated. Any help will be most welcome.

      Example attached.