Recipe: The item’s age

For how long have you stocked a specific item? Use the item’s age to define how long a new item is “new”.

WHAT:

This calculation gives you the item’s age in days calculated from the first time you stocked it.

WHY CALCULATE THE ITEM’S AGE?

New items, known as items being phase-in, need in particular attention. After having calculated the item’s age, you can set up an extra category for “new items” and analyze them separately. When setting up the extra category, you should consider: How long is a new item “new”? 180 days? Or less?

COLUMNS NEEDED IN THE CALCULATION:

• Date created (DATE) or
• First day in stock (DATE)

FORMULA:

FileDate()-days([Date created])