Trying to calculate savings using two blended data sources.

Hello,

I am trying to create a calculated field using 2 different data sources. The data sources are linked based on year/LOB. Essentially, for Commercial + Medicare I want the SUM(FY savings) from data source 1, and for (Medicaid) I want it to pull the SUM(Savings_Fy) from data source 2. Right now I have the below expression:

IF ATTR([LOB]) = 'Commercial' THEN SUM([dashboard_summary_prevloss].[FY Savings])

ELSEIF ATTR([LOB]) = 'Medicare' THEN SUM([dashboard_summary_prevloss].[FY Savings])

ELSEIF ATTR([LOB]) = 'Medicaid' THEN SUM([Savings_FY])

END

The expression pulls the correct value for Medicaid, however it pulls blank values/null for Commercial and Medicare.