I am trying to divide the total of two fields. The first is currency, the second is a number. Wanting currency as a result; eg total weekly pay / total hours worked = average hourly pay.
Here’s what I’ve tried and both have come back as INFINITY:
SUM...
Thanks for the advice everyone. Here’s a screenshot of what I’m working with currently. I’ve tried the rollup and linking within the table and to a different table but can’t seem to figure it out. I’d prefer to keep this all on the same table since i...
