Summary Report
I think I am missing something obvious with a summary report I am trying to build. I have a lot of projects. Some projects have been submitted, some have been approved, some have been canceled, some h...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendA summary report may only have 1 Project appear once, and that is your obstacle that you want a detail record to be summarized more than once on the same report.
But you can summarized many different fields! That is your wiggle room here.
So you will need to create a field on each record for fields like
Num. Approved. This will be a 1 or a 0.
Num. Submitted. This will be a 1 or a 0.
Num. Cancelled. This will be a 1 or a 0.
So a single project could be a 1 on each of the above.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
But you can summarized many different fields! That is your wiggle room here.
So you will need to create a field on each record for fields like
Num. Approved. This will be a 1 or a 0.
Num. Submitted. This will be a 1 or a 0.
Num. Cancelled. This will be a 1 or a 0.
So a single project could be a 1 on each of the above.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
But even so, then don't I have to Group by one, THEN by another, THEN by another? Or do I use them in the summary section, and if so, how do I incorporate the total cost?
------------------------------
Mike Tamoush
------------------------------
------------------------------
Mike Tamoush
------------------------------
- MarkShnier__YouA summary report will allow you to have multiple fields for the summarize what. That will be separate from the group by.
I think in your case this will be a one line report and you will need a dummy field to summarize on, like a field that calculates to the word "ALL".
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- That mostly works, and I can get all my items as wanted up top as summary columns, but I cant come up with a trick to see my total costs for each one of those columns.
------------------------------
Mike Tamoush
------------------------------- MarkShnier__YouWell its the same story, you will need to have 3 more fields on the record.
But Plan B is If you really want to lay out the information on a "square" type layout, you would need to create a helper table with just 1 record in it and summarize the totals up to that record.
Then you could lay them out on a form nicely.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------