When you create a calculated column in ABC Analyzer (see link), you have a variety of predefined functions at your disposal. You can combine these functions as you like, which makes creating a complex formula easy. In the usual “Edit Formula” dialog (that you find by clicking “Functions->Add” in the top menu in ABC Analyzer) the […]
Let’s look at how easy it is to calculate new columns in ABC Analyzer. Example, suppose we want to calculate a new column called Turnover rate. We open the “Edit Formula”-dialog by clicking “Functions->Add” in the top menu in ABC Analyzer: In the “Field name” textbox, we type Turnover rate to give the new column […]
We recently made some changes to the functions handeling dates in ABC Analyzer. These changes were made to mirror the way that Excel handles dates in formulas. As of version 4.1.0 of ABC Analyzer, the base date for all date operations will be Jan. 1st 1900. There is one important difference from Excel though! Excel considers […]
As of version 4.1.0 of ABC Analyzer, it is possible to ignore columns not needed for analysis or calculation. This highly anticipated feature allows you to mark columns as “Ignore” during the import phase which will cause them to be discarted from the dataset.
ABC Analyzer includes some nice new features regarding grids. It is now possible to lock selected columns in the left side of the grid. To enable this, you simply need to right click the grid and select the columns you wish to lock/unlock from the “Locked columns” submenu.
One of the more common questions we at ABC Softwork get is; what is the correct way to categorize products? We would love nothing more than to give a simple answer to this question, but the fact is that there isn’t just one – there are many. Before we can even begin to discuss how to categorize, five questions need to be answered: What is the […]
With the latest version of our software it has become even easier to save, reuse and access previously defined settings and analyses: ABC Project files enables you to pick up where you left off, and share analyses with your colleagues. ABC project file is a new feature in ABC Analyzer, which basically allows you […]