Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 the...
  • jdbuchanan71's avatar
    7 years ago

    Hello Anonymous 

    Give this a try

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