Using summary totals in another report
Hi, I added the values of a field in a summary table. Now I need to compare that summarized total number to another number in another table... How do I make a report and do this formula? Thanks. ...
Forum Discussion
Joe,
Can you describe your tables and any relationships involved between the tables? It will make it easier for us to help you if you actually said what the tables represented, for example Budgets or Sales.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Can you describe your tables and any relationships involved between the tables? It will make it easier for us to help you if you actually said what the tables represented, for example Budgets or Sales.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Tracking attendance in 'Attendance' table. (child of 'Associates' table)
different types of absences cost different amount of "points"
1/2 NF = .5
1 NF=1
NCNS = 3.5
I built a summary table that totals the different types of absences and gets me a total points per Associate.
My challenge is that Each Associate started with a different Allowable NF amount... For instance Associate A is allowed 7 and Associate B is allowed 5.
The number allowed per Associate is stored in the parent table 'Associates' per each Associate.
I would like the calculate the remaining points...
If Associate A started with 7 allowed but has accumulated 4 points in absences, then the remaining would be 3 points.
------------------------------
Joe Blouin
------------------------------
different types of absences cost different amount of "points"
1/2 NF = .5
1 NF=1
NCNS = 3.5
I built a summary table that totals the different types of absences and gets me a total points per Associate.
My challenge is that Each Associate started with a different Allowable NF amount... For instance Associate A is allowed 7 and Associate B is allowed 5.
The number allowed per Associate is stored in the parent table 'Associates' per each Associate.
I would like the calculate the remaining points...
If Associate A started with 7 allowed but has accumulated 4 points in absences, then the remaining would be 3 points.
------------------------------
Joe Blouin
------------------------------
- One Associate has many Attendance
On the relationship, simply make a summary field to summarize the points.
Alternatively, make three summary fields to count the # of:
1/2 NF
Then duplicate that for the other two absence types
No doubt you will also need a time period filter on that. Be sure to have the filter be "relative", ie don't lock it in for the year 2022, but make it for "the current Year", or the Previous 1 year. You don't want to have to adjust the summary field properties each year.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Perfect. Worked like a charm. that opens up so many other options for me also. Thanks so much Mark!
------------------------------
Joe Blouin
------------------------------
