SUM Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=SUMIF Function |titlemode=append |keywords=planfix, function, SUMIF, sum if |description=SUMIF Function }} '''SUM()''' — is a function that sums all values when calculating a formula. It is applied to each element of the multiplying variable. == Format == *SUM(expression) Arguments: '''Expression''' - a mandatory parameter, a variable, or a formula with the final sum of several strings. == Example == For example, you have a data tag "Serv...") |
|||
| Line 16: | Line 16: | ||
For example, you have a data tag "Service", and you want to calculate the total cost of all services. To do this, specify the function: | For example, you have a data tag "Service", and you want to calculate the total cost of all services. To do this, specify the function: | ||
<nowiki>SUM({{Data Tag.Service.Cost}})</nowiki> | <nowiki>SUM({{Data Tag.Service.Cost}})</nowiki> | ||
To get the total cost of services that may be provided more than once, you must multiply the cost by the quantity and then add it all up. At the end, you specify a formula like this: | To get the total cost of services that may be provided more than once, you must multiply the cost by the quantity and then add it all up. At the end, you specify a formula like this: | ||
Revision as of 14:31, 20 February 2024
SUM() — is a function that sums all values when calculating a formula. It is applied to each element of the multiplying variable.
Format
- SUM(expression)
Arguments: Expression - a mandatory parameter, a variable, or a formula with the final sum of several strings.
Example
For example, you have a data tag "Service", and you want to calculate the total cost of all services. To do this, specify the function:
SUM({{Data Tag.Service.Cost}})
To get the total cost of services that may be provided more than once, you must multiply the cost by the quantity and then add it all up. At the end, you specify a formula like this:
SUM({{Data Tag.Service.Cost}}*{{Data Tag.Service.Amount}})
Important
- The function SUM () can contain any formula that consists of functions.