Back to zzTakeoff Community Channel LogoFeature Requests
Steve G
28d 15h

Length Field Shows No Data

Planned

Hi All,

I have bored piers of depth 1.6 meters each, and quantities of 71 and 28 piers respectively. I would "Length" column to display the total length of piers as: 113.6m, 44.8m

  • Quantity × Depth = Total Linear Meters
  • For example: 71 × 1.6 m = 113.6 m, and 28 × 1.6 m = 44.8 m.


Is there a way around to have the "Length" column reflecting this calculated value results (e.g.,113.6m, 44.8m) rather than showing nothing?

1
Casey Krueger 26d 0h

Just a quickie work around, haven't done an in-depth, but you can create an item for the Count. Where the Item has a formula that x1.6

Then in the report, show group by Item

Steve G 25d 19h

Thanks Casey,

I can't find a way around because I still need the volume formula to work

At present Count parent have under the "Measurement Type":

  1. Count with Diameter & Depth
  2. Count
  3. Count with Diameter


Under the current Measurement Type “Count with Diameter & Depth” (Count with Diameter), it seems there it isn't direct field for Length.


Create a formula in the child items or the report section like:

Length = Depth * Count


I'm also experimenting with ZZ, but so far based on my experience... You will want to create a custom calculated field within the child items or parent report level that calculates Length as above.


If you want to derive cost based on labor hour rate and production rate per linear meter or foot, define:

The system is not supporting formulas at present to be implemented direct into "Cost Each" like in PlabSwift which it is easier at list for me

Cost Each = Labor Hourly Rate * Production Rate per Linear Meter, or foot


Thanks so much, Casey. Although I’ve wandered off the original subject, I truly appreciate your help

Casey Krueger 25d 19h

This might be a round about way to get it listed, but if you get a material item, put the formula in it, then attach it to the item you can kind of have it listed, here is a report, but its in LF / CY (Since I am in US)

I am also waiting for the down flow / up flow on formulas. Then its going to start kicking.


Kyle Bonde - Vertical GC 4d 20h

I also could use the VLF of pier depth to show up! Understood I can do a custom item formula, but that is getting to hard to setup for our people, simple is better!

Steve G 4d 19h

The formula is currently set to display CU M. Additionally, I need it to show the total VLF or VLM under the Length column. It would be ideal if the formula displays either VLF or VLM depending on whether the measurement system chosen is Imperial or Metric, respectively.


The drop-down box under the Measurement has Linear / Perimeter. I presume, if the option is added for Linear too, that will show the length of added columns or bored piers.

You must be logged in to post replies. If you don't have an account you can signup here.