I am curious about exposing the system Variables Formula [qty] and [Units] on folders.
I have created a couple formulas to control what is totaled up as follows:
I have also created a checkbox for the takeoffs to override the formula if I don't want the value included even if the unit matches.


What I am doing is Setting the Item Unit on the folder, then the children look to that to see if it should be included in the Item Qty.
The Sum by Unit Then lives on the folders and simply grabs these values back up to the folder.
What would be epic for the advanced item report, when it is grouped by folder, if the qty was exposed, and it was grabbing the variable [sum by unit], and the System property [units] was set at the folder level as well.
Then this report would not need the two extra columns "Bidbow item quantity" or "item unit":

The values would just live int he "qty" and "unit" column.
furthermore:
The value that is in thss "Other Item", could be inline with the folder.

I realize this could prob be accomplished with a manual sum takeoff somehow, but then the grouping function goes away on the advanced item report.