I need a report to summarize a totals columns
I use an app that tracks employee hours(actual vs budget) by job by year and quarter closed. I want to be able to calculate an efficiency by quarter for each employee. I have tried creating a summary ...
Forum Discussion
Hmmm so there is a limitation of Quick base that the reference field of a relationship (the field on the right aside of the relationship) may not be derived by a lookup field. It's a technical limitation which is well known to the product engineers, but not easily solved without hurting Performance.
Which of those fields (employee #, YYYY or Q ) is a lookup field? .... And then we will need to see how to get around that by either finding a field to use to represent the EE which is not a lookup field, or else there is a way to copy the lookup field into a so called "Scalar" field (data entry) field using a saved table to tabla import and an Automation to run each day.
Which of those fields (employee #, YYYY or Q ) is a lookup field? .... And then we will need to see how to get around that by either finding a field to use to represent the EE which is not a lookup field, or else there is a way to copy the lookup field into a so called "Scalar" field (data entry) field using a saved table to tabla import and an Automation to run each day.