Calculate Fields

Calculate Fields Manual · Chapter 7

Example of usage – Calculate Fields for Vtiger CRM

This chapter describes a few of an uncountable set of usage examples in a simple way, i.e. how to define fields, filter and set up a calculation.

7.1 The Annual revenue per Organization for current Fiscal Year

In this example the annual revenue is calculated per organization and result is written to already existing Vtiger organization module field “Annual Revenue”.

  1. Select target module, Organizations
    Calculate Fields Setup
    Example step 1
  2. Select target field “Annual Revenue”
    Example step 2
    Example step 2
  3. Select related module “Invoice”
    Example step 3
    Example step 3
  4. In order to achieve this we need to create custom view/filter in the related module Invoice
    To define that you would like to see only invoices from Current FY and in addition only Paid invoices as seen below
    Example step 4
    Example step 4
  5. Select operation “SUM”
  6. Select column/related field “Total”
  7. Click on Save button – The Annual revenue per Organization for current Fiscal Year button
    Example steps 5, 6, 7
    Example steps 5, 6, 7

Some examples of possible modifications:

  • Change the period of interest using standard filter.
  • Change the advanced filter to see not paid invoices, etc.
  • Change the operation to see average revenue per invoice or to see the count of the invoices.

7.2 Our Tip for You

When you create a Field that is calculated by Calculate Fields, good option is to have this Field as Read Only.

How to make field as Read Only:

  1. Go to Menu – CRM Settings – User Management – Profiles
    Choose Profile you want to change by clicking on name of the profile
    Tip
    Tip
  2. Now, please click on Edit button – Our Tip for You button

    Tip
    Tip

  3. Next, find your module and click on Our Tip for You

    Tip
    Tip

  4. Find your Field(s), set to Read Only and save it by using Save button – Our Tip for You button
    Tip
    Tip

    Now, your Field(s) is(are) protected.

Need help with Calculate Fields?

Our support team answers questions about installation, templates and settings.