Forum Discussion
Impactful IndividualDataformat.Error: We couldn't convert to Number
It could be that there's an earlier step in your query that's trying to convert that column to a number, try looking to see whether there is and removing it
I have the same issue but I remove some steps in applied steps frame, the value return blank instead of text value.
Please instruct me how to fix it
Thanks
Linh
Skilled SharerIn the applied steps pane there should be a step that sets the data types. I would find the column causing the error and change the data type to "type any". You can enter this in the Formula bar at the top of the page.
I tried to get data again & this is the applied steps
I cannot see the change type step.
In the format bar, I cannot see Type Any, can you pls show me the capture screen?
- jcarville
You are looking at the "Errors in Billing condition" table when you should be looking at the "Billing condition" table. In there, a step should exist for Changed Type. Find the problem column and change it as shown below:
If the formula bar below is not showing you need to select Formula Bar, which can be found under the View tab.
Thanks Jcarville. I can do it :smileyvery-happy: