Multiplying hours with an hourly rate to get a total. What am I missing?

[Ben_Lee]

I just updated a “Pay Tracker Template” that I had posted quite a while ago. It was one of my first big “aha” moments in Coda working with different schemas. I had different pay rates to track depending on the job being done and I also didn’t want all previous data to change if pay changed, if I got a raise for instance. So this tracks different types of pay over different categories and also different time periods…

Pay Tracker Template

I created a Pay Tracker Template to log pay for hourly jobs. There are two pay rates in the example, Office and Field, and then various scalers of these rates, like Overtime at 1.5x regular pay. Bulk pay items are also included, like single sum Bonuses or Reimbursements. You can also track raises and pay changes for both rates without overwriting data previous to these rate changes. There is also a YTD (Year to Date) page with a dropdown to choose the year you’d like to review. All Tables are…