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. -...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan 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
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- 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__YouI 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
------------------------------
