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

Sindhusha Kukkadapu

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

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

1. IFNULL("Your Metric Column", 0)This ensures that all null values are converted to 0s before visualization.
2. Switch to Table View after applying the custom formula.
3. 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!