To calculate amounts in a row definition, you can use a row total formula ( TOT) or a calculation formula ( CALC).
Note |
---|
You can export row totals to an Excel spreadsheet, but you cannot export calculations. |
Row total formula
Use a row total formula ( TOT) for simple addition and subtraction functions. You can apply the formula to every column in a row, or you can specify ranges.
For more information, see Use a row total in a row definition .
Calculation formula
Use a calculation formula ( CALC) for complex functions, including addition, subtraction, multiplication, division, and IF/THEN/ELSEstatements. These calculations can be limited to columns and individual cells.
For more information, see the Use a calculation formula in row definition .