How to construct this table?
I have a table of Projects.
Each Project has the following fields (for this example, they can be checkbox fields)
Requested by/Submitted to Customer In Preparation Submitted to HNC Approved b...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp, no FQs required.
Just make a set of helper fields.
[RSO Count] ( you can rename that later when its working to just RSO or whatever touy want your column to read)
The formula is IF([multiple Choice]="RSO",1)
Then
[ESO Count] ( you can rename that later when its working)
The formula is IF([multiple Choice]="ESO",1)
etc for all your columns on the proposed report.
Then make a summary report and under Summarize What - add in those 4 helper count fields, then plus the numeric cost summary field.
The reason that the formula is not
The formula is IF([multiple Choice]="ESO",1, 0) is that you want the user to be able to drill into the supporting detail and not get drill down hits on the zeros.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark,
Won't that only work if each Project Record can fit neatly into a single category? If I simplify to the chart below (where number of SOs is simply ESO+RSO+.....), I will have the need for the same record to be counted in the Submitted row, AND the Approved row AND the Executed Row. At a certain point, projects actually fit into multiple categories simultaneously.
Where I am lost is - the original Summary Sort needs to be by SO Category right? But if I do that sort, won't it only be able to put the record into one of the categories?
------------------------------
Mike Tamoush
------------------------------