Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to show 0 value instead of null value in a calculated formula column in OTBI report? — 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

How to show 0 value instead of null value in a calculated formula column in OTBI report?

Accepted answer
11
Views
3
Comments

Summary:

How to show zero value instead of null value in a calculated formula column in OTBI report

Content (required):

I have a column 'Variance' which has value that is derived from the difference between two fields (a DFF and Standard field). We want to see 0 value instead of any null value in that column.

Tried with IFNULL() function but for some reason, it's not working for a calculated formula field (see the formula below) and showing incorrect value for the column. When IFNULL is removed, the values are showing correctly but we are seeing null values.

Calculated Formula:

"Project"."PJF_PROJECTS_DESC_FLEX_ESTIMATED_CAPEX_COST_"-"- Cost Distribution Line Capitalization Measures"."Capitalizable Cost In Transaction Currency"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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