How to Remove Null Values in FDI Pivot Table and Display Data by Period, Ledger, and Status?

Question

Hi everyone,

I've created a pivot table in FDI, but it's displaying multiple rows due to null values. I want to remove those nulls so the data is shown in a single line, grouped by period, ledger, and status. Additionally, I’d like to apply specific colors based on the status of the period and ledger.

Is there a way to handle this in FDI? I’d really appreciate any guidance or tips if someone has faced a similar situation.

Thanks in advance!

Sumanth V -Oracle · Accepted Answer

@User_2O5NO -To handle NULL values in your Pivot Table and replace them with 0s in Oracle Analytics Cloud (OAC), try the following:

* IFNULL("Your Metric Column", 0)This ensures that all null values are converted to 0s before visualization.
* Switch to Table View after applying the custom formula.
* In the Table View, use the “Suppress Rows” option to hide rows where all metrics are 0 or as needed. This helps in displaying only meaningful rows.

This combination of formula and layout adjustment should help produce the desired output.

Hope this helps!