Comments
-
Ah, yes that did it. It works now. Thanks for your help.
-
I am getting a syntax error when I input the case statement. Is there a misplaced ( or ` ?
-
I think this case statement is exactly what I am looking for. Thank you!
-
Yes, basically, the logic should look for all MCR Replacement products first and name them as such regardless of the payer (Aetna, UHC, etc). Second, the logic should look for Medicare payers and call them as such, and finally it should look for the major payers listed in my formula and call them as such and the remaining…