AnsweredAssumed Answered

Simple Count

Question asked by guit4eva on Jul 14, 2017
Latest reply on Jul 14, 2017 by philmodjunk

Might be approaching this the wrong way, cause I can't seem to get what seems like a simple task:

 

I have the following:

 

Layouts:

 

Lay1:

A form with dropdown that goes to the select user

 

Lay2:

A form displaying the records

 

Table:

 

[Name] [Level}

[John] [1]

[Sally] [1]

[Peter] [2]

[Sue] [1}

[Josh] [2]

 

What I am trying to do is have a section on Lay1 that displays the total count of each level, ie:

 

Levels 1: 3 Users

Levels 2: 2 Users

 

Should I be using a calculation or summary field? Or would I need to use a script? I initially thought that I could make a calculation field with something like:

 

if [(getfield(Level)) = "3"]

count (Level)

EndIf

 

But clearly that's incorrect

 

If someone could point me in the right direction, I'd really appreciate it. Thanks in advance!

Outcomes