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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Handling NULL values in calculations

    edited Dec 13, 2022 7:01AM in Taleo Enterprise 2 comments

    Summary

    Summing columns in OBI that contain NULL values results in a NULL sum

    Content

    Does anyone know how to handle NULL values as part of a calculation?  I have columns in which some are returning NULL values and some are not - i want to SUM these columns, but when I do, if there is a NULL value present, the SUM is always NULL.

    For example, col1 + col2 = col3
    If col2 is null, then col3 evaluates to null even if col1 <> NULL.

    I have tried CAST and IFNULL functions within the column formula,but it does not seem to help.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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