Content
View differences
Updated by Tobias Dillmann 12 months ago
* A calculated value is added as a new project attribute
* A calculated value has these details:
* Name
* Formula
* For all projects
* The formulas can include the following attributes from that project:
* Integer
* Float
* Mathematical operators: +, -, \*, /, ( and )
* Other calculated values
* **Order of operations:** Automatic application of the mathematical rule where multiplication and division are performed before addition and subtraction, unless parentheses dictate otherwise
* Additionally, constants (float or integer numbers) can be added
* In order to trigger the selection of the attributes in the field, the user can use the command "/" as implemented in the Automatically generated subjects.
* The command triggers a dropdown to open with sections for:
* Mathematical operators
* Calculated values
* The calculated value should be stored in the database. When displaying the value, it should not have to be calculated on the fly.
* Reasons:
* Lots of read access from multiple places.
* Difficulty to calculate a calculated value if it in turn includes a calculated value again.
* Note that the value stored in the database has to be recalculated under certain circumstances: <mention class="mention" data-id="64352" data-type="work_package" data-text="###64352">###64352</mention>
* Error handling
* In calculations, there is error handling for **circular references**.
* In case the user includes text that is **not an integer or a float,** the field will display an inline error: "Only numeric values, project factors, calculated values and mathematical operators are allowed"
* In case the mathematical operation fails (e.g. because of a **division by zero error**), the field will display an inline error.
**Out of scope**
* List factors (Project attribute of type list with values)
* Displaying the calculated value (e.g. on the project overview or the project list)
* A calculated value has these details:
* Name
* Formula
* For all projects
* The formulas can include the following attributes from that project:
* Integer
* Float
* Mathematical operators: +, -, \*, /, ( and )
* Other calculated values
* **Order of operations:** Automatic application of the mathematical rule where multiplication and division are performed before addition and subtraction, unless parentheses dictate otherwise
* Additionally, constants (float or integer numbers) can be added
* In order to trigger the selection of the attributes in the field, the user can use the command "/" as implemented in the Automatically generated subjects.
* The command triggers a dropdown to open with sections for:
* Mathematical operators
* Calculated values
* The calculated value should be stored in the database. When displaying the value, it should not have to be calculated on the fly.
* Reasons:
* Lots of read access from multiple places.
* Difficulty to calculate a calculated value if it in turn includes a calculated value again.
* Note that the value stored in the database has to be recalculated under certain circumstances: <mention class="mention" data-id="64352" data-type="work_package" data-text="###64352">###64352</mention>
* Error handling
* In calculations, there is error handling for **circular references**.
* In case the user includes text that is **not an integer or a float,** the field will display an inline error: "Only numeric values, project factors, calculated values and mathematical operators are allowed"
* In case the mathematical operation fails (e.g. because of a **division by zero error**), the field will display an inline error.
**Out of scope**
* List factors (Project attribute of type list with values)
* Displaying the calculated value (e.g. on the project overview or the project list)