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

Question

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?

CRashmi · Answer

Getting same issue. Anyone with the answer?

Jason_Fenner · Answer

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

Thanks,

Jason

MohithRai · Answer

@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