Suppress zeroes and nulls in FDI Data Visualization

Question

I am hoping to suppress all of the rows showing with null or zero in the screenshot below, while retaining all rows that show values other than zero. I've seen some options for an Expression Filter using the 'Aggregate By' function, but have not yet been successful. I'd also like to convert the nulls to zeroes if at all possible. Any help is most appreciated, thanks!

Sai Poorna · Answer

I’m encountering the same issue in the report. I want the data for one ledger to appear in a single row, but currently, it's showing up in three separate rows. Please help me resolve this."

Andrew at MKL · Answer

Hi PhaniPhani,

Can you describe what additional details would be helpful? I'm hoping to suppress rows where only zeroes or nulls exist, and to convert all nulls/blanks to zeroes.

Phani Srikantam · Answer

Hi Andrew,

Can you give more details on the use case so that we can help.