DataFormat.Error: We couldn't convert to Number.

[Anonymous]

Hi, basically my database consist of staff id..now most staff id are all digits, for example

1234
4519
8901

However, there are staff id which includes a letter, for example

B1290
C9021

The error states DataFormat.Error: We couldn't convert to Number. - but the thing is my data type is not set to numbers (it is set to this logo ABC123, and i have also tried setting the type to text but it did not work. Please help 

[JamesRobson]

There are occasions when the error message DataFormat.Error: We couldn't convert to Number is misleading as the real issue is with a calculation on a totally different step.

For example I was doing a simple Free Inventory + Quarantined Inventory calculation but there was an Error value in a single Quarantined Inventory field and I was getting the DataFormat.Error: We couldn't convert to Number  error message on the last step of my query even though the calculation was done several steps before!

Although this doesn't directly answer your question it might give you a starting point (you could copy the query then delete steps one at a time until you find the error goes away then you know the last step you deleted had the problem??)

[ChielFaber]

If you add a new step at the end with keep errors. You will only get the rows with values that give an error.  That might help in pin pointing where the error occurs.

[ChielFaber]

Could you provide the steps out of the advanced editor? It might be that PQ converts your column automaticly or in there's a conversion in an earlier step.

[Anonymous]

is it this the one you are referring to 

the only type we changed was year