Often your data set does not contain all the columns you need for making great analyses. You can calculate and add additional columns in ABC Analyzer.
Popular extra columns:
- "Product age" in days, use it to define "new products"
- The turnover rate
- Contribution margin
- Consumption per day (based on 12 month historical data)
New to formulas or not accustomed to spreadsheets and Excel? Go to our recipe section, it's the easy way to add extra columns to your data
Create new columns
- Name the new column
- Insert the desired formula
-
Use "[" to gain access to columns already in the data
As long as your formula is invalid it's red, once you've entered a correct the window turns white and the OK-button is active.
Formulas
You can find a large collection of formulas here: Formulas in ABC Analyzer