Skip to Content

Function ValueColumn

3804  Formulas, functions and formats

Functions are used in the formulas for calculating the rate and amount of the Salary Types, as well as in the calculated columns of the Settlements.

ValueColumn(column number)

Type returned Number
Context Settlementss
Parameters Type Description
column number Number

Number of a settlement column
Description

The amount of the column of the statement, only if this column is already calculated.
Example

ColumnTotal(2951)-ColumnTotal(3130;3210;3240;3305;3410)-ColumnTotal(3610;3611;3620;3630;3650)-ColumnTotal(3640)

This formula allows you to obtain the value of column 38 in the “Salary certificate 08-2027” statement, i.e. the Net salary. It calculates values
already obtained in the calculation of the Gross salary (column 33), AHV (column 35) and LPP (columns 36 and 37). Thanks to the ValueColumn function, you only need to enter:

ValueColumn(33)-ValueColumn(35)-ValueColumn(36)-ValueColumn(37)

In addition to simplifying the formula, this function also results in a gain in speed since it avoids having to recalculate values already obtained in the previous columns.
Function ValueColumn