Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
IIF to divide users into exchange - error parameter does not match

Answered IIF to divide users into exchange - error parameter does not match

  • Thursday, June 16, 2011 9:29 PM
     
     
    Sign In to Vote
    0

    Trying to split users into different homeMDBs based on last name but get error "parameter of function iif does not match" when entering into flow.

    IIF(EQ(Left(lastName,1),"A"),"01",IIF(EQ(Left(lastName,1),"B"),"01",IIF(EQ(Left(lastName,1),"C"),"02",IIF(EQ(Left(lastName,1),"S"),"10","12"))))

    Any thoughts?

    Thanks,

    Bill
     

All Replies

  • Friday, June 17, 2011 7:15 AM
     
     
    Sign In to Vote
    0
    I've seen this message when using long CustomExpressions. Don't know if there's a typo or bug in the UI. Usually it resolves when CustomExpression is splitted or using CustomExpressions inside Functions (UI controls).
     
  • Friday, June 17, 2011 6:23 PM
     
     Proposed
    Sign In to Vote
    0
    I know the casing can be a problem too I think. I always use "Eq" instead of "EQ" not even sure "EQ" is accepted. What Robert suggest is indeed true. If I get wierd erros I try to simply the expression and untill the error is ironed out.
    http://setspn.blogspot.com
    • Proposed As Answer by UNIFYBobMVP Sunday, June 19, 2011 2:05 PM
    •  
     
  • Sunday, June 19, 2011 2:06 PM
     
     Answered
    Sign In to Vote
    0

    Thomas is correct - try the following:

    IIF(Eq(Left(lastName,1),"A"),"01",IIF(Eq(Left(lastName,1),"B"),"01",IIF(Eq(Left(lastName,1),"C"),"02",IIF(Eq(Left(lastName,1),"S"),"10","12"))))

    Bob Bradley, www.unifysolutions.net (FIMBob?)
    • Marked As Answer by frerockan Monday, June 20, 2011 8:34 PM
    •