CASE when help for balance value
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.
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):