Mauro 
| How to Compute Entities Without Having Repeated Lines in the Bill of Quantities Mauro 2026-03-10 17:36:41
I want to share a support request
Request
I have computed a series of identical entities (beams, columns, etc.) but in the bill of quantities, I find the information repeated across “n” measurement lines.
Is there a way to display a single line with the total quantity?
Answer
When writing the measurement formula, besides using single variables like length, area, etc., it is possible to use FUNCTION variables that allow you to perform @SumC() [Compressed Sum – TOTAL only], @SumE() [Extended Sum (formula)], and @Count [Count values – Number of Entities].
These variables allow you to have the total quantity in a single line without repeated lines.
Specifically, the variables allow you to:
@Count: function that counts the entities linked to the current measurement.
@SumC(): sums the content inside the parentheses (numeric value, variable, or formula) for all entities linked to the current measurement and outputs only the final calculated value in the bill.
@SumE(): sums the content inside the parentheses (numeric value, variable, or formula) for all entities linked to the current measurement and outputs, in the bill, a formula containing all values resulting from the measurement performed in the model.
EXAMPLE
The following example clarifies the above.
Suppose you have selected four IfcWall elements with lengths of 2 m, 3 m, 4 m, and 5 m, and assigned to them a measurement containing, in the “Length” field, the formula @SumE($BaseQuantities.NominalLength$).
When displaying the bill of quantities, PriMus-IFC will apply the formula to all entities (automatically or manually identified) linked to the measurement and find the four IfcWall.
For each IfcWall, the expression ($BaseQuantities.NominalLength$) will be evaluated to determine its length.
The results of the evaluation for each entity are then summed into a single expression (2+3+4+5) that will be displayed in the bill.
If, instead of the @SumE function, the @SumC function had been used, the procedure would be the same, but only the value 14, resulting from the expression evaluation (2+3+4+5), would be displayed.
IMPORTANT
When using the @Count, @SumE, and @SumC functions, it should be considered a Single Line computation mode.
In this case, no other variables should be combined; otherwise, the lines will always be repeated “n” times. |
