About Using "Not Inlist" function

[Former Member]

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"

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

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

[former_member221192]

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

[Former Member]

Hi,

try this:

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

Hope that helps

Andreas