Excel365 formulas will be null when inserted by Alteryx as string and re-imported

[liangcaixia]

I have tried to write the excel formula (like =IF(OR(R2="CNY",R2="KRW",R2="TWD",R2="INR",R2="BRL",R2="THB"),(M2*P2)/L2,M2*P2)) a .XLSX file,

And the cell can calculate the formula and output the correct result in the specific cell.

But my issue is that if I import this file by another Alteryx process, this cell will shown as "[Null]" rather than the correct calculate result.

Does there has any suggestions?

[messi007]

@liangcaixia,

Could you share a sample data?

My suggestion is implemente the formula in Alteryx instead of having it on Excel.

Regards,

[IraWatt]

Hey @liangcaixia,

When I tried to replicate this Alteryx took the result from the formula. Maybe something else which is causing this?

[MohithRai]

@liangcaixia H,

Were you able to solve this issue?

Recently I have been facing the same issue. Alteryx workflow reads cell which is calculated using a excel formula as NULL. 

But the weird thing that I observed here is, If the input file is opened and saved manually. Then the workflow is able to read the value.

Thanks,

Mohith

[Jason_Fenner]

Were you able to resolve this? I'm seeing a similar issue now. 

Thanks,

Jason

[CRashmi]

Getting same issue. Anyone with the answer?