Discussions

 View Only
  • 1.  Need help with auto sum formulas

    Posted 01-03-2023 16:19
      |   view attached
    Hello I need some help to create a formula to auto sum labor time with labor dollars.
    This is what I have:
    ToHours([Repair Time.])*[Labor] 
    But it is not working on all entries. Please advise.

    ------------------------------
    Denise Keck
    ------------------------------


  • 2.  RE: Need help with auto sum formulas

    Posted 01-03-2023 16:26
    Can you tell us what is in the field  [Labor]?  Is that the Labour rate?  I don't see it in your screen shot.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Need help with auto sum formulas

    Posted 01-03-2023 16:34
    So the repair time would be the labor time and repair costs would be the labor dollars  so I would like to input the repair time and calculate the repair costs. it was at one point calculating for me and now there is nothing and it will not let me manually adjust it as there is a formula in the report.

    ------------------------------
    Denise Keck
    ------------------------------



  • 4.  RE: Need help with auto sum formulas

    Posted 01-03-2023 16:38
    I understand that you want to enter the duration of the labour and then multiply it by some kind of rate to convert it into dollars.  

    I suggest that you put that field called Labour on the form so you can see what is in it and also look at the ifeld properties to see where it comes from.  It's probably empty for that record.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------