Conditional column for 10 digit account number

[Anonymous]

Hello All, 

I'm trying to create a conditional column between account numbers from the AccountID column. i would like to breakdown the account numbers with the accounts that have 10 digits in them and i'll call them BLAZE and the accounts with less than 10 digits i'll call them Pharos. 

I'm having trouble defining this. Any help would be appreciated. 

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

Give this a try

AccountID Group = 
IF ( LEN ( Table[AccontID] ) = 10, "BLAZE", "Pharos" )