Views: 1303 (Data available since 06.02.2017)

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.





Courses developed by «Bitrix», Inc.