Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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?

in Reporting and Analytics for ERP 6 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"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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