Solved: Help with selection expression - Page 2

Lucinda_Mason · 05-11-2020 12:12 PM

I am trying to get the list of TYPEs from a TYPE_SLICE where
ARCHIVE<>TRUE, and based on the PI_NO of the USER, either TYPEs with a FAMILY_GROUP = JFP or FAMILY_GROUP=GEO AND both should have those with FAMILY_GROUP=ALL

This expression works for GEO and JFP individually:
AND([ARCHIVE]<>TRUE,
IF(LOOKUP(USEREMAIL(), “Users”, “USER_EMAIL”, "PI_NO”)>3,
[FAMILY_GROUP]=“JFP”,[FAMILY_GROUP]=“GEO”))

But that does NOT include the records with ALL.

I tried several expressions but can’t get it to work. What am I missing?

AND([ARCHIVE]<>TRUE,
IF(LOOKUP(USEREMAIL(), “Users”, “USER_EMAIL”, "PI_NO”)>3,
SELECT(OR([FAMILY_GROUP]=“JFP”,[FAMILY_GROUP]=“ALL”),
[FAMILY_GROUP]=“GEO”,[FAMILY_GROUP]=“ALL”)))

Thanks.

WillowMobileSys

Yes and you could make it a little easier to read by re-arranging it like this:

AND([ARCHIVE]<>TRUE,
    OR(
       [FAMILY_GROUP]=“ALL”,
       IF(LOOKUP(USEREMAIL(), “Users”, “USER_EMAIL”, "PI_NO”) > 3,
            [FAMILY_GROUP]=“JFP”,
            [FAMILY_GROUP]=“GEO”)
    )
)

View solution in original post