Sample Calculation Syntax

Body

The following syntax should be used in calculations for columns or rows as part of Financial Definitions:

For Columns:

Format for summation of a column range: {c1:c5} = Sum of column 1 through 5.
Format for adding columns: {c1}+{c2}+{c3} = column 1 + column 2 + column 3.
Format for subtracting columns: {c1}-{c2}-{c3} = column 1 - column 2 - column 3.

For Rows:

Format for row ranges: {r1:r5} = Sum of row 1 through 5.
Format for adding rows: {r1}+{r2}+{r3} = row 1 + row 2 + row 3.
Format for subtracting to rows: {r15}-{r21} = row 15 - row 21.
Performing multiple calculations on a row: ({r15}-{r21})/{r15} = (row 15 - row 21)/row 15.

Title

Sample Calculation Syntax

URL Name

1915318186

Related Articles