I have account numbers that need to be shortened with certain criteria.
First, if the full Account is not 8 digits, a zero needs to be added to the account (Adj Account) to make it a full 8 digits.
Second, to create the Short Acct, I need to return a minimum of 3 numbers. The Short Acct ends before the first zero after a minimum of 3 numbers are returned.
Account Adj Account Short Acct
1230012 01230012 0123
1300010 01300010 013
20200012 20200012 202
Solved! Go to Solution.
You can use the following formulas to generate the desired results:
Adj Account: PadLeft(tostring([Account]), 8, '0')
Short Acct: left([Adj Account],3)