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
  • 0

    Rounding set on the item windows is only applied when printing a report. In this case, if you want the quantities rounded on reports, there is a Round quantities option on the Report Options dialog.

  • 0 in reply to Tony Colburn

    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.

  • +1 in reply to Antonio RESTREPO
    verified answer

    It does work, you just have to take into account the units and conversion.

    So it sounds like for concrete material you'd like truck loads.  and your conversion is 10CY/Load - enter that in.   You would then set the rounding to "up to the nearest "Load"

    And on labor you are looking for Days.   Conversion is 8 hr / Day and you are rounding up to the nearest Day.

    In my attached example I have 5463 of vapor barrier and 2000sf/roll and rounding up to the nearest roll giving me 3 rolls.  Enjoy!

    Then when you print reports - chose combine items and round quantities and you get 3 rolls @ 375 / roll = $1125.

Reply
  • +1 in reply to Antonio RESTREPO
    verified answer

    It does work, you just have to take into account the units and conversion.

    So it sounds like for concrete material you'd like truck loads.  and your conversion is 10CY/Load - enter that in.   You would then set the rounding to "up to the nearest "Load"

    And on labor you are looking for Days.   Conversion is 8 hr / Day and you are rounding up to the nearest Day.

    In my attached example I have 5463 of vapor barrier and 2000sf/roll and rounding up to the nearest roll giving me 3 rolls.  Enjoy!

    Then when you print reports - chose combine items and round quantities and you get 3 rolls @ 375 / roll = $1125.

Children
No Data