| Excerpt | ||||
|---|---|---|---|---|
| ||||
You can now transform, aggregate, and perform calculation on your requirement's data with this new feature. |
...
Now, Requirement Yogi lets you perform such calculations directly from Confluence. In particular, you can combine requirement fields, properties, external properties and other data related to your requirements into a formula to extract the data that you need. What’s more, you can perform aggregations based on data from linked requirements (parent or child). This is particularly useful if, for example, you want to extract the sum of man-days needed to meet a requirement based on an external property of its child requirements.
Use cases: What
...
calculations can
...
be done ?
Estimate the cost of a requirement
1.2 * (@Man\ days * 150 + ext@Manufacturing\ Cost)
...
Here, we see that the result for requirement AA-003 is marked as error because the property @Man days used in the calculation is not a valid number.
...
Estimate the total cost of a parent requirement
SUM(ext@Cost, from@Refines)
...
Detect when a parent requirement is over budget
SUM(ext@Cost, from@Uses) > @Budget
...
Detect when parts composing an assembly are too heavy
SUM(@Weight, child@Refines→child@Uses) > @Max\ weight
...
Here, we see that the result for requirement AA-003 is marked as error because the property @Weight used in the calculation is not a valid number.
...
Tutorial: How to perform calculations?
To perform calculations, simply open a traceability matrix and add a calculation column.
...