You have opened a project. Utilities > Master data > Form > Open > [Open].
- Insert > Placeholder text. Select the Placement tab in the subsequent dialog and, next to the Properties formatted / calculated field, click [...]. Select the Calculation format element and click (Move to the right).
- You have double-clicked a placeholder text (or have selected the Properties popup menu item. In this case several texts can also be marked). Select the Placement tab in the subsequent dialog and, next to the Properties formatted / calculated field, click [...]. Select the Calculation format element and click (Move to the right).
In this dialog you can use format elements to create a calculation formula for project and parts data in order to output this in reports.
Overview of the main dialog elements:
This field shows all format elements that can be part of a calculation formula. To load a format element for the calculation formula into the Selected format elements field, select it and then click ( Move to the right).
You wish to automatically calculate and output the total price of parts, including a discount:
Total purchase price * (100 - discount) : 100
You have already entered the discount percentage in the parts management under the menu items Utilities > Parts > Management in the Prices / Other tab in the Discount field.
Select the Calculation format element in the dialog Format: Property. Enter the following format elements in the specified sequence in the dialog Format: Calculation:
Format element |
Meaning |
---|---|
Placeholder text |
Select the Placeholder text format element and in the subsequent dialog select the Part reference data placeholder element with the Total purchase price Currency 1 property. |
* |
Select the * format element. |
( |
Select the ( format element. |
Number |
Select the Number format element. Enter a value of 100. |
- |
Select the - format element. |
Placeholder text |
Select the Parts data format element and the Discount property. |
) |
Select the ) format element. |
/ |
Select the / format element. |
Number |
Select the Number format element. Enter a value of 100. |
The following format elements are available in the Available format elements field:
Format element |
Meaning |
---|---|
Placeholder text |
Opens the Placeholder texts - <Form type> dialog. Allows insertion of placeholder text into the calculation formula. |
+ |
Adds |
- |
Subtracts |
* |
Multiplies |
/ |
Divides |
( |
Groups several format elements together with the format element ). This defines the priority of calculation in the calculation formula. |
) |
Groups ( several format elements together with the format element. This defines the priority of calculation in the calculation formula. |
Number |
Opens the dialog Format: Number. Allows entry of a constant number into the calculation formula. |
This field contains the format elements comprising the format of the calculation formula.
The value in this field defines the minimum number of digits to be used for the result. This value only affects the positions before the decimal point. If the result has fewer digits before the decimal point than specified here, then the missing digits are padded with the filler character you have defined in the Filler character field.
Missing positions are filled in with this filler character. The number of digits filled depends on the value you entered in the Minimum number of digits field.
If you entered a value of "4" in the Minimum number of digits field and the value "0" as the Filler character, numbers are output as follows: "0001".
The value in this field defines the minimum number of decimal places displayed in the result. If the result has more digits than allowed after the decimal point, then the digits are rounded to the permitted number of decimal places. If the result has fewer digits than allowed after the decimal point, then the missing digits are padded with the filler character you have defined in the Filler character field.
If this check box is selected then decimal places are never padded with filler characters. If the result has fewer digits than allowed after the decimal point, then the result remains unchanged. If the result has more digits than allowed after the decimal point, then the digits are rounded to the permitted number of decimal places.
In this group box you define the conditions under which the project / parts data is not output. Select an operator from the drop-down list. Enter a value for the condition in the field below this.
- Do not hide: No condition applies for the project data. The selected project data is always output.
- =: The selected project data is not output when it has a value equal to that specified in the field below.
- >: The selected project data are not output when they have a value greater than that specified in the field below.
- <: The selected project data are not output when they have a value smaller than that specified in the field below.
- >=: The selected project data are not output when they have a value greater than or equal to that specified in the field below.
- <=: The selected project data are not output when they have a value smaller than or equal to that specified in the field below.
- <>: The selected project data are not output when they have a value unequal to that specified in the field below. Only project data having this value is output.
Including preceding separator:
If this check box is selected then the project data satisfying the conditions in the fields above is not output, including any preceding separator. This setting affects the Separator format element preceding the Calculation format element.
Including following separator:
If this check box is selected then the project data satisfying the conditions in the fields above is not output, including any subsequent separators. This setting affects the Separator format element coming after the Calculation format element.
See also