Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Thank you! This was a huge help. What I did was break the account down into 6 digits and 2 digits. Then, I did a sub-query that listed all accounts ending with '99'. This also had the first 6 digit account. From this sub query, I did another sub query based upon the 6 digit account list in the first sub-query and filtered…