Question Re: Count function in webi in Technology Q&A

Count function in webi

jm12 — Mon, 19 Aug 2024 23:44:02 GMT

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!

Re: Count function in webi

MichaelGrackin — Tue, 20 Aug 2024 13:35:34 GMT

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

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

Re: Count function in webi

nscheaffer — Tue, 20 Aug 2024 15:46:21 GMT

Check the documentation on the Count() function.

Have you tried using All?

Noel

Re: Count function in webi

jm12 — Tue, 20 Aug 2024 22:36:42 GMT

Thank you Michael. This has solved my problem.