Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
CASE when help for balance value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

CASE when help for balance value

Received Response


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!