How to show 0 value instead of null value in a calculated formula column in OTBI report?
How to show zero value instead of null value in a calculated formula column in OTBI report
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.
"Project"."PJF_PROJECTS_DESC_FLEX_ESTIMATED_CAPEX_COST_"-"- Cost Distribution Line Capitalization Measures"."Capitalizable Cost In Transaction Currency"