All numeric fields (quantity, price, factor) allow the use of formulas.
Formulas include the standard mathematical operations like addition, deduction, multiplication and division.
Additionally, formulas may include variables and expressions for tags and producers added to the accounts.
Formulas and variables can be used in Budgeting as well as in Financing.
Variables:
Let's say you have defined a variable "SD" (=Shooting Days). To use it in a formula, just type in the variable name, i.e. SD/5.
Tags & producers:
With tags and producers there are two ways to include them. Either you want to count the number of instances a certain tag (or producer) appears in your budget, or you want to sum up all accounts that have a certain tag (or producer).
This is how you do it:
SUM_PROD("producer") will return the sum of all accounts with this producer
COUNT_PROD("producer") will return the number of accounts with this producer
SUM_TAG("tag") will return the sum of all accounts with this tag
COUNT_TAG("tag") will return the number of accounts with this tag
Example 1: Let's say you want to count the number of people in your crew and have marked all corresponding accounts with a tag "Crew". You are planning to give everybody a gift of 30$. You can type:
COUNT_TAG("Crew")*30
Accounts:
You can also reference another account in a formula:
ACCOUNT("account_number")
Example: You want to add two accounts. Type: ACCOUNT("10101")+ACCOUNT("10102")