gvoshol 73146 - Thursday, February 15, 2018 5:20 AM
You need to reverse the WHEN's in your last sum. Currently the first condition is a superset of the second, so all Medicaid including Dual will be caught in the first WHEN.
Thank you for catching that. Just fixed it!
-Mark MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.