Calculation examples with the LinkNotions concept map

Calculation

Functions IF, AND, AVERAGE, NOW

Fonction

Example

The example in the LinkNotions concept map

Click on the image to open the concept map.
In the map, click on a concept to activate it.

IF

If an ULM aircraft does not have a parachute, its maximum takeoff weight is 450 kg.

If an ULM aircraft has a parachute, its maximum takeoff weight is 472.5 kg.

We can therefore calculate the maximum takeoff weight (A3) using the presence of a parachute (A2)

IF (A2 = ‘Yes’, 472.5,450); Which means: If the plane has a parachute, then the maximum takeoff weight is 472.5 kg, otherwise it is 450 kg.

You see that there are two possible methods.

  1. Write the formula in the “Expression” field: IF (A2 = ‘Yes’, 472.5,450)
  2. Use the possibility with the “Conditions”: B2 = ‘Yes’

Warning:

The comma must be written with a point. Write 472.5 and not 472.5.

Text in a formula must be written in double or single quotes ‘Yes’.

IF; AND

Here an example with the two functions “IF” and “AND”.

In a store, a customer must fulfill two conditions to obtain a bonus:

  • A minimum of the purchase amount (€ 5,000)
  • A minimum number of purchases (5x)

Criterion 1 is indicated in the notion “Criterion 1”

Criterion 2 is indicated in the notion “Criterion 2”

Each client has two subnames:

  • Total purchases
  • Number of purchases

Each client has a main sub-name

  • Bonus

The main sub-name is calculated from the two sub-names and with the values ​​of the two concepts containing the criteria.

The formula is entered in the “Expression” field in the notion “Customer” .

The formula is written for client A (Method 1) : IF(AND(clia.topu>id1,clia.nbpu>id4),clia.topu*10%).

Read: If the total purchase is greater than criterion 1 and the number of purchases is greater than criterion 2, then the bonus is equal to the Total purchase times 10%, otherwise the bonus is 0.

  • “clia” is the reference for the improvement of client A
  • “topu” is the sub-name for formulas for the sub-name “Total purchases”
  • “nbpu” is the sub-name for formulas for the sub-name “Number of purchases”
  • clia.topu allows to refer to the sub-name “Total purchases” of customer A
  • clia.nbpu allows to refer the sub-name “Number of purchases” of customer A
  • id1 is the fixed number of criterion 1; id1 is used here to refer to criterion 1
  • id4 is the fixed number of criterion 2; id4 is used here to refer to criterion 2

AVERAGE

If you want to calculate the average of the value of several notions.

AVERAGE (A1,A2,A3)

You will enter the formula in the “Expression” field of the notion Average .

NOW

TODAY

To display today’s date, just write NOW () or TODAY () as a formula.

Note:

To allow more text to be shown, we can increase the size of the squares. To do this, proceed as follows:

  • Click on the “Preferences” button at the top right of the screen.
  • The “Schema Properties” window is opened.
  • Increase the width and height of the diagram. In our case we put a width of 200.