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.
Comments
2 comments
Can MULTIPLY a total on a report X a percentage? For example, I want to multiply Net Income Before Tax by 30% to show "ESTIMATED INCOME TAX" on a custom report. Is this possible? If so, what would be the formula?
I would also like to know if you can add multipliers in the Row and Column calculationss
Please sign in to leave a comment.