I have a report that looks at accounts which have at least one E code and
possibly up to 15 but I only want to pull up to the first 3.
If the account only has 2 E codes then ter e code column would be blank and if only 1 E code then sec e code column would also be blank.
acct # prim e code sec e code ter e code
123 E8190 E0008 E0299
456 E6000 E0030
789 E3001
I need to know how to write the formula that will pull the first thru third E codes and ignore any code is not an E code or is the 4th or greater E code.
The E codes are in the dx cd records
dx_cd_1
dx_cd_2
dx_cd_3
dx_cd_4
up to....
dx_cd_15
IP Logged