Forum Discussion

DeniseKeck's avatar
DeniseKeck
Qrew Trainee
2 years ago

Need help with auto sum formulas

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

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    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
    ------------------------------
    • DeniseKeck's avatar
      DeniseKeck
      Qrew Trainee
      2 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        2 years ago
        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
        ------------------------------