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
ReportingCustom Financial Reports
Skip Feed

End of Feed
2 Chatter Feed Items