Calculated Data Fields

Use BLR Rosetta's powerful calculated data fields to create custom data columns for your database. For example, if your database contains fields for cost and price, you can easily create a new field for profit:

Profit = Price - Cost

BLR Rosetta will calculate this formula for each record returned in your query, allowing you to use the new data column in all of your grids, charts, maps, and reports.

The editor includes dozens of built-in functions to manipulate dates, numbers, and text, and it supports nested parentheses for building complex expressions.

You can add as many calculated fields as you need, and because calculated fields are always created on the fly, there is no need to modify your database or waste valuable storage space.

Here is a screenshot of the Calculated Data Field Editor in action: