Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

How do I calculate cost per development hour from an average?

I want to automate the process of calculating the cost of development, based on an entry field (development hours) - so when a developer enters their project hours, it automatically calculates the cos...
App builders
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Ron,
Good to see that you made it work.

Here are two suggestions for the future

You only need 1 IF in QuickBase, so you need to undo your excel background.

If(
[Designer]= "Name", [Hours Worked] * 40.9,
[Designer]= "Name", [Hours Worked] * 38.6,
[Designer]= "Name", [Hours Worked] * 34)

But the right way to do this is not to hard code it.

There should be a table of designers and their rates.  Then setup a relationship where 1 designer has many rates and pull that down as a lookup field for the Rate.

Then I would set up a snapshot field on that rate lookup https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html so that you do not change the historical records, when the rates are changed over time.
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    Thanks for the additional info (for guys like me, this is the stuff that helps tremendously!).  The single If statement does make it so much easier!

    The additional ideas on the relationship table is brilliant, as is the snapshot.  Going to give those a try so you may be seeing me back here asking questions when it doesn't work :)  
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Correction to my post above.

    There should be a table of Designer with their Rates.

    Then set up a relationship where 1 Designer has Many Orders (or whatever you call your table that now has the formula)