Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement where I want to add 2 leading zero if the department is 1 character, if it is 2 character 1 leading zero and if it is 3 leave is as it is.
So From the attached file I need something like this
000,002,003,004....012,013,014....104,108
Any help would be greatly appreciate it.
Try one of these
Num(Dept_No, '000') as Dept_No
or
Text(Num(Dept_No, '000')) as Dept_No
Try one of these
Num(Dept_No, '000') as Dept_No
or
Text(Num(Dept_No, '000')) as Dept_No
Try
Text(IF( Len(Dept_No) <3, Repeat( '0', 3-Len(Dept_No))& Dept_No,Dept_No )) as Dept_No