Numeric values can be calculated and entered into document fields. Lists can be used for demonstration as presented below
Create a new list with a set of the following number type fields:
- Amount,
- Contract expenses,
- Tax (6%). Calculated automatically,
- Total amount. Calculated automatically.
The Contact expenses field won't have "required" option specified. If this field contains values, they will be taken into account in calculations.
Note: Depending on the PHP settings,
number field values can be displayed in
Scientific notation.
- Create a template sequential business process and configure it to start when a new element is added.
- And and configure first activity Modify document that will calculate a total amount tax as follows:
Field: Tax (6%). Calculated automatically,
Value: ={=Document:PROPERTY_s}*0.06,
where
{=Document:PROPERTY_s} is the value of Amount field.
- And and configure second activity Modify document that will calculate total amount with account of all deductions:
Field: Total amount. Calculate automatically,
Value: ={=Document:PROPERTY_s}-{=Document:PROPERTY_contract}-{=Document:PROPERTY_tax},
where
{=Document:PROPERTY_s} is the value of the Amount field,
{=Document:PROPERTY_contract} if the value of the Contact expenses field,
{=Document:PROPERTY_tax} is the value of the Tax (6%) field. Calculated automatically.
