PivotTable Disappears when Error replaced to 0.

[countryfan_nt]

Hello friends, Hope all is safe!

Created pivot table, via PowerQuery, PQ combines multi CSV files.

When I finished, I went to the PQ data module, and in column named Cash, I got: data format.error we couldn't convert to number.
I highlighted column and replaced Error to 0, and when saved PQ module, PivotTable disappeared. How can I replace errors to zero without losing the PivotTable?

Thank you so much in advance!

 

[sandy666]

do that before creating pivot table

 

[pjmorris]

Perhaps better still, rather than hiding the error by setting it to 0 (why is 0 a better figure in a cash column than any other?) find out what caused the error and adjust your PQ to deal with it. The most likely cause will be characters in the column that don't translate to a number. If that is the case then see if you can extract the meaningful information that is in the cell.

HTH