I like to know how many Scouts need the various rank requirements. Right now, I have custom reports for each rank (Under Star) and for each requirement, I count how many people need it and put it into a spreadsheet. It helps us in planning our troop meetings to know where we need to put our efforts.
If a total could be added for each rank requirement, that would be great. The total could be defined in the filters as total having or total needing.
When I need to do that sort of thing, I usually just export the report as a CSV and set up formulas to pull the parameters of interest. That way, I can provide the information directly to the SPL/PLs who can track how things are changing over time (for example).
For a simple potential calculation is is very complex - you would have to define what is SUM group.
For ranks there is the checkbox for “just show scouts that have not earned” - that solves your issue
Agreed on the backend you’d have to define what sum does. I was hoping it could be figured out.
On your second line, I’m not quite sure how that setting helps me. I already have that set. How does it solve my isue?
Right, which is very similar to what I’m doing currently. I’m asking for a change to make it a bit easier where I’m not counting rows or creating formulas in an exported spreadsheet. I’m not saying I can’t do it manually, just asking for a change.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
© 2019 Boy Scouts of America - All Rights Reserved
