Count function in webi

[jm12]

I'm having trouble with a seemingly simple formula in webi

I am trying to count the number of times a username appears in the list. When ther are multiple usernames in the username object, they will have a diffent position number. Below is a sample of the data:

Username	Position Number	Count
JDOE	12345
JDOE	54321

I have tried the following formulas but keep getting a result of 1 when there are more than 1 
=count([Username])
=count([Username]) foreach ([Position Number])
=count([Username]) forall ([Position Number])
I have also tried reversing Username and Position Number as well adding the sum function in front. 

I'm hoping someone has some advice on what I am doing wrong or something else I could try. 

Thank you for your help! 

[MichaelGrackin · Accepted solution]

Try the following as a variable and place the variable in the Count column of the table.

=Count([Position Number]) In ([Username])

[jm12 · Accepted solution]

Thank you Michael. This has solved my problem.

[nscheaffer]

Check the documentation on the Count() function.

Have you tried using All?

Noel