Forum Discussion

MJHickey's avatar
MJHickey
Qrew Member
10 years ago

Summarize (count) a numeric field with a condition?

Hello,

I have a field that gives a "0" (false) or "5" (true) for "if meets goal".

I would now like to be able to summarize how many of the "0" and "5" there are for a specific group or Service Area.  For example, the main field is Service Area and the Service Area can have tens to hundreds of rows of data (see below):

Aquatics   Swim class 1    0

Aquatics   Swim class 2    5 

etc...

I have tried creating s summary report but it will only total the 0 and 5's.  I then tried to "define a calculated column" but can seem to find a formula that will work (I am a novice at this...).  What I want to show is how many "0" there are and how many "5" there are by Service Area (maybe by total AND percent) and maybe even graph this to show managers.  I am trying to show a manager how many courses "meet" the goal and how many "don't meet" the goal.

Any help would be great!

Thanks.

Formulas and functions
reports and charts
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    10 years ago
    No problem.
    Make a field called [# of 0's] with a formula of
    If([Rating]=0,1,0)


    Make a field called [# of 5's] with a formula of
    If([Rating]=5,1,0)

    Then do a summary report and calculate the total of those fields on the report.
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    What if in general I want to do a "count" summary where there are indefinite numbers of options. For example, I want to summarize events by the date they occurred, and each event was completed by a user, and I want a summary of the number of users who created events that day.

    Similarly, each event is related to an object in another table, and I'd like a summary of the number of objects associated with events each day.

    The "# of events" field is automatic but I wish I could get a "count" of any numeric field.

    Thanks,
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      I suggest that you post this is a new question and describe your tables and their relationships.