AnsweredAssumed Answered

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

Question asked by Kishan_Canoo on Oct 19, 2016
Latest reply on Nov 9, 2016 by 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.

Attachments

Outcomes