Calculated Column, Formulas, and Filter Expressions

You can use a formula editor to specify a calculation that is based on other contents of the table. You can, for example, calculate percentages or total values from different columns, or define an expression for a filter.

Expression Categories

As an aid, easymap offers various expressions within the formula editor to perform calculations. If you select an expression category, different operators and expressions are available in the window Selection. You can add them to the formula text field above by double-clicking.

Note: Always use a period instead of a comma as decimal separator (e.g. 0.25). Please do not use thousands separators; strings in quotation marks "ABC".

Special features in the easymap explorer

For the display and use of calculated columns in easymap explorer the columns not only have to be specially formatted, but some of them have to be calculated first. Here it is important that texts or data can be taken from individual columns and output in a new column.

Example

In the example data, the entry from the column Weblink is used as text for the link to the company's homepage.

Web link homepage Calculated column - Display Internet
website http://www.lutumtappert.de <a href="http://www.lutumtappert.de" target="_blank">Website</a>