Reports: Formulas: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{#seo: | |||
|title=Reports: Formulas | |||
|titlemode=append | |||
|keywords=planfix, reports, formulas | |||
|description=formulas in reports | |||
}} | |||
Planfix reports let you use simple formulas in columns to calculate values. Formulas use data entered in columns located to '''the left of the formula column''' (up to the column with the formula); they use standard operators. The data from the columns is denoted by the letter designated to the column: | Planfix reports let you use simple formulas in columns to calculate values. Formulas use data entered in columns located to '''the left of the formula column''' (up to the column with the formula); they use standard operators. The data from the columns is denoted by the letter designated to the column: | ||
https://pic.planfix.ru/pf/7p/lBU30l.png | https://pic.planfix.ru/pf/7p/lBU30l.png | ||
Formulas are calculated in order from left to right, in one pass: rows are filled with values from the database for all non-formula columns, then formulas are calculated. As a result, formulas normally use values from the database up to the formula column, but they don't use the values of other formulas. | Formulas are calculated in order from left to right, in one pass: rows are filled with values from the database for all non-formula columns, then formulas are calculated. As a result, formulas normally use values from the database up to the formula column, but they don't use the values of other formulas. | ||
You can use [[Standard functions | standard operators and Planfix functions]] in formulas. | You can use [[Standard functions | standard operators and Planfix functions]] in formulas. | ||
Latest revision as of 08:45, 13 November 2024
Planfix reports let you use simple formulas in columns to calculate values. Formulas use data entered in columns located to the left of the formula column (up to the column with the formula); they use standard operators. The data from the columns is denoted by the letter designated to the column:
Formulas are calculated in order from left to right, in one pass: rows are filled with values from the database for all non-formula columns, then formulas are calculated. As a result, formulas normally use values from the database up to the formula column, but they don't use the values of other formulas.
You can use standard operators and Planfix functions in formulas.