CASE when help for balance value

Summary:

I have an OTBI analysis where I need to pull the sum of balance values for specific balance type between two dates. If an employee does not have that balance type, results should show 0.

Content (required):

I'm trying to pull the sum of all balances between two dates and the result is showing 0 for all employees, even though there are employees with the balance type. Case expression is CASE WHEN "Balance Types"."Balance Name" = 'Regular Salary SM' THEN "Balance Value"."Balance Value" ELSE 0 END

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):