Category - Calculations

Articles

Aging Reports
You can generate reports that show the calculated age of assets or inventories based on a determined date. The reports will be generated in CSV files that you can either download, or export to Google Sheets or Excel for constant live updates, or use with Power BI or Looker Studio for interactive visualization. The basic […]
Comparison Calculations
You can compare the numeric values of the data captured by your custom fields. The comparison can be between two custom fields or between a custom field and an arbitrary value. For example, you can generate reports where quantities of inventories are below their re-order point or even a specific amount. The condition for comparing […]
Minimum And Maximum Values Calculations
You can calculate the minimum and maximum values for similar records captured multiple times and also contain numeric values. The reports will be generated in CSV files that you can either download, or export to Google Sheets or Excel for constant live updates, or use with Power BI or Looker Studio for interactive visualization. The […]
Statistics
You can use the statistical tool at the top of the tables to generate reports that analyze the data captured by the custom fields. Click on the dropdown arrow to expand the statistics reports section. After that, click on the three-line icon to choose a report to add under this section. Once the report is […]
Sum And Average Values Calculations
You can calculate the sum and average values for similar records captured multiple times and also contain numeric values. The reports will be generated in CSV files that you can either download, or export to Google Sheets or Excel for constant live updates, or use with Power BI or Looker Studio for interactive visualization. The […]