In a column of type formula, the SUM_ELEMENTS () function is used to sum the numeric values of the selected columns.
Formula
SUM_ELEMENTS (Column1, Column2)
Example 1
SUM_ELEMENTS (Direct Cost, Indirect Cost)
I made the sums of my Direct Cost and Indirect Cost columns to have the result of my Cost Cost in the column of the same name.
Note: I can sum columns of type number, but also type text provided they contain only numeric values. However, in order to avoid typing errors, the number columns should be used.
Comments
0 comments
Please sign in to leave a comment.