AnsweredAssumed Answered

Summary of checkboxes

Question asked by timmcmanus on Aug 22, 2013
Latest reply on Jun 7, 2016 by mikebeargie

I have a field named Funding that uses a value list from another file, and the value list is displayed as 15 checkboxes. The value list in the other file can be edited, so it can change over time.

 

I want to create a summary report counting the number of times a value appears in Funding.

 

For example, I may have data like this:

 

Funding
Cash

Cash

Check

Donation

Credit

Cash

Credit

 

My summary report would look like this:

 

FundingCount
Cash3
Check1
Credit2
Donation1

 

I tried to create a sub-summary report with Funding and a summary field that was a Count of the Funding field. This works great counting the total amount of records using the Funding field, but I cannot figure out how to create a summary for each individual value. To further complicate things, the value list that creates the checkboxes will change over time, so I cannot rely on the value list to return all possible values entered into the field. I need to be able to support historical reporting, so I need to be able to report on all possible values in the Funding field.

 

Can anyone give me any guidance to approach this dilemma? I'd prefer not to change the schema or the implementation of the Funding field.

Outcomes