Formula

Result

Pieces*Volume

Returns the total volume.

TOTAL(COLUMN5)

Calculates the final result for column 5.

_IF_(Material=”B*”)Volume_ELSE_Area

Returns the volume when the name of the material begins with the letter B. Otherwise, the area is returned.

_IF_(@OBJ@=3)Height_ELSE_Length

Returns the height if the element is a column (object number 3). Otherwise, the length of the element is returned.