Reading data from Excel file with cells having formula

[ayush_mishra]

I am reading an Excel file and cell has formulas in it. Cell is formatted as percentage.

Alteryx is reading it as vString because cell contains alphanumeric values. I can not replicate excel formula in alteryx and have to read it from calculated cell. Below one example of the calculation and instead of doing the calculation myself (because a lot of other formulas are being applied before getting to this stage) I am reading last column.

V1	V2	V3	V1/(V2/V3)
0.124	1216	1000	0.101973684210526

I want to read this as 0.101 (last column) but not unable to do so. Below snapshot of problem values being read by Alteryx especially one with very long decimal places.

[caltang · Accepted solution]

Use the Multi-field formula to convert that field to a number (Double datatype), and it will read as a number and not a string. It will then be possible to do your mathematical operations thereafter.