...
Note Concerning Currencies of Order Totals: The CALC_OrderTotal field appears in the system's functional currency; however, an organization can modify the calculated field based on a different currency type. Contact Aptify Technical Support for more details.
Adding -Calculated Fields to List View
These fields provide the following information:
- Orders Placed: This field shows the total number of orders where the campaign is referenced in the order's Campaign field as either the Campaign of the order itself or the CampaignCodeID of any of the order lines.
- Order Total: This field shows the total amount of all orders where the campaign appears in the order's Campaign field.is used as either the Campaign code of the order or any of the order lines. In cases where the campaign is used on order lines, the calculation aggregates the total of the entire order on which the campaign is used, not just the total of the applicable order lines. Note that this field appears in the functional currency but it is currency agnostic (in other words, if linked orders are in multiple currencies, these order totals are added together regardless of the different currencies involved).
...
In the example below, the Widget Campaign has 5 orders currently linked to it with a total value of $1,980.
Campaigns View with -Calculated Fields
Note to Administrators
If your organization uses campaign codes extensively and your users experience a greater than expected response time when opening the Orders form due to the calculations associated with these virtual fields, you may want to consider adding an index for the CampaignCodeID field to the Orders and OrderLines entities. Contact your Aptify consultant for assistance.