Q & AIs there a list of formula types available for zz
I am just wondering if there is a round function I can use in formulas but also what other functions are available beyond + - / * if ?
([Segment count]*2)+if([Linear:m]<2.4,0,([Linear:m]/2.4))
This formula is counting the ends of each board but I also want to count the joints if the maximum board length available is 2.4, anything over 2.4 gives me a fraction but I only want to count multiples of 2.4 over 2.4 , that is where I thought the round function might help
Hi Kevin,
Try this formula
([Segment count]*2)+if([Linear:m]<=2.4,0,floor([Linear:m]/2.4)-1)
The formula counts 2 ends per segment, then adds the number of joints required based on 2.4m board lengths.
Joints are calculated by dividing the total length by 2.4m, rounding down to whole boards, and subtracting one to get the number of joins between boards.
Hope this helps
Thank you!
That works but not until the linear gets to 4.8 then is ok
I have fixed it by removing the -1 at the end.
Thanks for your help!