Overview

In Dataforce ASAP, calculations can be performed on appointment products and are often used to determine a certificate discount.

Job calculations are visible through the job’s calculations tab (blue).


Each appointment can have multiple calculations performed through different calculation types which in turn can have primary and secondary calculations.

Primary and secondary calculations are displayed under the same calculation type and are usually complementary.

For example:

  • Primary = Certificates (Energy multiplied by certificate conversion factor).
  • Secondary = Energy.


When a product is attached to an appointment, Dataforce ASAP will automatically apply any calculations to the product based on the restrictions applied through the configuration options below.

An appointment’s calculation is executed when users save questions or manually select the Recalculate button on the calculations tab.


See below for an example of a calculation in Dataforce ASAP.


Calculation Configurations

There are four mandatory components to build calculations:


A calculation’s components (modifiers / modifier groups) can be sourced and modified via appointment information such as:

  • Suburbs.
  • Products.
  • Question Answers.

Detailed Discounts

The detailed discount setting, providing a more intricate overview of invoice discounts, can be accessed by following these steps:

  1. Click on the (configuration icon).
  2. Navigate to “Calculations” in the dropdown menu.
  3. Access “Calculation Types.”

  4. Choose a specific calculation.
  5. Click on “Discounts” within the selected calculation type.

  6. Check the detailed discount box to enable this feature for a more detailed representation of discounts on the invoice


The detailed discount setting gives a more detailed invoice compared to the default invoice as seen in the images below
Allowing the modification of rate + discount type.


Detailed

Default


Calculation Rates

If enabled, a calculation’s current rate (i.e. discount rate) is visible at the bottom left of a job’s calculations tab. This rate can be defined in three places throughout Dataforce ASAP:

  1. The calculation tab on an appointment’s job.
  2. The appointment’s agent.
  3. The calculation type.


Appointment-level discount rate

  1. Select the relevant calculation stage (quote / invoice).
  2. Select the drop down list under the ‘NEW DISCOUNT RATE’ section at the bottom left of the job’s calculation tab.
  3. Select Enter a new discount rate.
  4. Enter the new rate as a decimal (e.g. 15.25).
  5. Select RECALCULATE.


Example



(0 + (12 − 2) × 12 × 1.06 + 2000) ÷ 1000000 = 0.0021272


Modifier Group Modifier
Group 1
[+12]
[−2]
Modifier: 12
Multiplier/Divisor: 1 (Multiplication)

Modifier: -2 (Subtraction)
Multiplier/Divisor: 1 (Multiplication)
Group 2
[×12]
Modifier: 0
Multiplier/Divisor: 12 (Multiplication)
Group 3
[+2000]
[×1.06]
Modifier: 2000
Multiplier/Divisor: 1.06 (Multiplication)
Group 3
[÷1000000]
Modifier: 0
Multiplier/Divisor: 1000000 (Division)

As demonstrated through this example, the calculator does not consider order of operations.

Instead, each group is applied sequentially based on their sort order.

i.e. addition/subtraction will occur before multiplication/division if their group has a lower sort order.

In addition, the calculation begins with a base value of 0; this value is retrieved from the product’s calculation tab based on the appointment’s suburb.

It is important to note that if no modifier (addition / subtraction) values are defined in any calculation modifier, the base value cannot be zero as the calculation figure will result in 0 (e.g. 0 × 2 ÷ 4 = 0) .

Where to Next?