Forum Discussion
Conditional column for 10 digit account number
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.
Hello Anonymous
Give this a try
AccountID Group = IF ( LEN ( Table[AccontID] ) = 10, "BLAZE", "Pharos" )
1 Reply
- jdbuchanan71
Super User
Hello Anonymous
Give this a try
AccountID Group = IF ( LEN ( Table[AccontID] ) = 10, "BLAZE", "Pharos" )