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):
Tagged:
0