Rounding tab on database item form

SOLVED

What is the purpose of the rounding tab on the Database Item. For example, I have tried to round up to the closest drywall board (32 sq ft) or in the case of labor, to the next whole day. However, this feature does not seem to work. Am I missing a step?

Parents Reply Children
  • 0 in reply to Randy Snyder

    Thank you for your time responding to my question.

  • 0 in reply to Randy Snyder

    Thank you for your timely response, but I'm not looking to round item quantities.

    What I'm trying to accomplish is to round the Labor, Equipment and Material within the item to whole units, for example if the labor for a particular activity is calculated as 4 m-h, I would want to go to full day so in effect, rounding the labor to the next 8 m-h.  Or in the case of concrete, I would want the material to be round up to each 10 CY (average delivery truck size).

    I expected the rounding tab on the database item entry form would do that,  but it looks it does not.

  • 0 in reply to Antonio RESTREPO

    Okay. I will show you an example of materials rounded UP to the next full box. This will work for your concrete. (the Item's Unit of Measure will need to be CY, and your deviser will need to match). I have not set up something for labor, but I can't imagine it not working. Note that the labor and material will need to be on separate Items.

    This is the Calculation inside the Assemble. 

     IF( qProvide Material? , cCove Base Material Calc ,0) the  cCove Base Material Calc - is a nested Formula.

    It looks like this:  ROUNDTO( afHow Many Linear Ft /120,1,1)  The How Many Linear Ft is a Formula allowing the user to input the needed LF. The cove base comes in boxes of 120 LF. So, If 90' are needed - One box will be priced. If 121' are needed, 2 boxes will be priced. If 2,000' are needed, 17 boxes will be priced, etc.