Time for action – creating a new formula
We will use the formula editor to create a new formula that multiplies the Amount and Quantity. Then we will place it in the Details section so it makes its calculation row by row. Finally, we will change the type of object for the Amount and change the format in which the numbers are presented. We will create a formula to make a calculation based on the Amount and Quantity of each of the rows and place this value under the label Total. We choose the Data tab, right-click on Functions, and choose the Add Functions... option:
In the new window, we go to Common | Open Formula and click on OK.
We will configure the formula we just created. First, we change its name:
Function Name =
FormulaTotal
-
Next, we specify the calculation that this formula will make. We press the
button to the right of the formula. This will open the formula editor.
In the lower-right portion of the formula editor, we see only the
=sign where it says Formula:.- The calculation that...
