Make your data work for you
Calculated Fields are a valuable feature built into your database. This powerful tool allows you to create formulas inside your database fields that dynamically produce specific information. Calculated fields are simple to set up and easy to use.
What are Calculated Fields?
Calculated fields are a special type of database field that allow you to generate information that can change when other data elements change. The value of the field is not stored within the database record, but is instead calculated or computed based on the values of other fields within that record using a specific formula. This formula can consist of values from other fields, constants, and the results of other formulas or functions. Fields like this are ideal when you need to calculate an answer based on a number of variables. For example, calculating a loan amount.
- Manage billing and payroll calculations
Group and subtotal database information to provide meaningful reports. - Generate invoices
Make calculations and produce easy-to-read invoices. - Forecast sales and revenue streams
Write formulas to determine sales goals and profit margins. - Perform currency exchanges
Covert dollars into euros and more. - Compute inventory value
Easily manage parts and inventory value.



