0 to empty cell in the table

[tax]

Hello,

I wanted to change data in the table from 0 to empty cell. How should I do?

Thanks,

[Matt_N]

Hi @tax

If the table columns are Number format, a null value should display as an empty cell instead of a 0. It looks like you're already formatting the data for the table in a JS query, so you could iterate the data and replace any 0's with null. Alternatively you could map the value of the column with similar logic:

Set the Mapped value of the column to the following, and it should turn the 0's into empty cells
{{item === 0 ? null : item}}

Example Before Mapping

Example After Mapping