Reading XLSX vs XLSB

[Jordan_Collins]

I have a WF that I run each day that sums values in my excel file on various tabs...I recent converted the base file to .xlsb extension in excel. When testing the WF with the .xlsb extension is giving me different values than the .xlsx version. I have tried various things in the WF to get me close the what the values should be, the most recent being using a multi field formula tool to replace commas in my sales values with nothing. This got me close but not exactly. Another approach that I tried was to convert the base file's values to numbers without commas. The result was identical to the replacing commas solution. Does anyone have any ideas? The first screenshot is the WF with the multi field formula tool and the second screen shot is of the result. The third screenshot is the results of the WF as an .xlsx version.

I have also tried a couple of macros without any luck. The first was the Christmas day Macro and the second was a file extension converter. 

[fmvizcaino]

Hey @Jordan_Collins ,

That is very weird. IF your values are set as double, I would suggest you changing it to integer to check.

One thing that happens with programming, alteryx included, are rounding issues.

https://medium.com/nerd-for-tech/floating-point-rounding-problem-in-programming-world-86c5639c102c

Best,

Fernando Vizcaino