cancel
Showing results for 
Search instead for 
Did you mean: 

About Using "Not Inlist" function

Former Member
0 Kudos

Hello Everybody ,

How can I use Not InList function in sum function ?

For example

I want to Total Employees number except the number of trainees .

[Personnel Type] not in list "Trainess"

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member

Hi

Using the eFashion universe I created query with just State and Quantity Sold.  I then created a variable called UV State defined as follows...

=If(Trim([State]) InList("DC";"Texas");[State];"Other States")

Note I had to trim State because apparently it has trailing spaces.

I then created a table with UV State and Quantity Sold which results in this...

Grant points if it helps.

Regards

Former Member
0 Kudos

=count([Emp Id]) where (not([Personnel Type]  inlist("Trainess")))

former_member221192
Participant
0 Kudos

=Count([empoyeeid] where([Destination]<>"Trainess"))

Former Member
0 Kudos

Hi,

try this:

=sum(if [Personnel Type] = "Trainess" then 0 else 1)

Hope that helps

Andreas