How to use fx functions

Judit -

Once created a column with Calculated formula Mark type, within the Formula generator press over fx button. When you press this button, the features listed below will appear:

- Weighted mean: it allows you to get the average of the columns that you want and apply their weight percentage. 

Once this option is selected, click on the + symbol. 

Select a column and specify its percentage.

Do the same operation with all the columns you need by clicking the + symbol again. Remember that the sum of the percentages must be a total of 100%.

Once you have entered all the values, click OK in the popup window and also, the OK button of the Formula generator to get the result.

NOTE: In the popup window which you select this Mark type, appears the check box. By checking this box, enables you to make the average of the columns that contain only data.

 

- Arithmetic mean: it allows you to get the average of all the values of the columns that you select. In other words, all add up and the result is divided by the total number of columns.

The procedure is almost the same as Weighted mean, you must press the + symbol in order to select each column you want to apply this function. 

NOTE: In the popup window which you select this Mark type, appears the check box. By checking this box, enables you to make the average of the columns that contain only data.

 

Sum: as the name suggests, it makes a sum of the values of the columns that you select.

Pressing the + symbol, you can select the columns that you want to keep in mind in order to obtain the sum of the values entered in all of them.

 

Max: it allows you to find the highest value of the columns that you select.

Pressing the + symbol, you can select the columns you want to take into account to show the maximum value of them all.

 

Min: it allows you to find the lowest value of the columns that you select.

Pressing the + symbol, you can select the columns you want to take into account to show the minimum value of them all.

 

NOTE: With the dropdown gray button displayed on the bottom left part of the Formula generator, you can select the tab that you want to get the information.

¿Tiene más preguntas? Enviar una solicitud

0 Comentarios

Inicie sesión para dejar un comentario.
Tecnología de Zendesk