Summarize a value in the same table
I'm building a new Table [Daily Time Cards], now trying to calculate for overtime. I built formula fields for week and year number, with the idea that I would query the same table for [Related Team M...
Forum Discussion
I figured it out.
Looks like ChatGPT gave bad advice - insert GetFieldValues into the mix. When I pulled that out I eliminated the error. I also decided not to try calculating the OT value on an individual timecard just for the sake of capturing the day it happened, but instead will break that out in the formula on the payroll page for hours > 40.
For those who are interested, here's a screenshot of the formula that worked, with comments inline.