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:





A form with dropdown that goes to the select user



A form displaying the records




[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)



But clearly that's incorrect


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