Create a column with Calculated formula Mark type

Judit -

The Calculated formula Mark type allows you to perform calculations of the columns you want.

As explained in the tutorial Create a column, Mark types allow you to define the configuration of the columns and in the case of the Calculated formulas, to perform calculations with the Formula generator and use exclusive features such as apply rounding and Conditional values.

To get started, create a column and assign this Mark type, by scrolling if necessary to find it.

Once configured Formula generator will appear, which lets you easily define the formula in two different ways: using the fx functions that comes by default or set it manually to perform more complex operations.

To manually enter columns into the formula press the drop-down button that appears at the bottom left part and of the list, select the tab you want to include columns. Once defined, click OK to apply it.

IMPORTANT:

You can copy the calculated formula by clicking on the column title with the right button and pressing the copy option. Then, right click on the column where you want to paste the formula and select the Paste as link option.

Captura_de_pantalla_2020-02-04_a_las_16.24.10.png

Learn how to calculate averages in this tutorial.

¿Tiene más preguntas? Enviar una solicitud

0 Comentarios

El artículo está cerrado para comentarios.
Tecnología de Zendesk