PivotTable Disappears when Error replaced to 0.

countryfan_nt

Well-known Member
Joined
May 19, 2004
Messages
716
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!
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

pjmorris

Well-known Member
Joined
Aug 2, 2012
Messages
1,916
Office Version
  1. 2016
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,823
Messages
5,544,534
Members
410,617
Latest member
niayuliawati
Top