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
MarkShnier__You
Qrew Legend
Qrew LegendJoe,
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
------------------------------