percentage and decimal place inconsistencies

Question

Hi there can someone help me with this issue..

I have an excel sheet filled with yield (percentages) and when I pull the data into alteryx the decimal place changes. Even more interesting is that the decimal place change is inconsistent across all the data

I have tried to calculate the yields manually and there is still an inconsistency( although a different inconsistency).

To make sure I have covered my back I have calculated the YIELD manually in excel and that works perfectly.

Can anyone advise on what might be causing this problem?

Best,

CoG · Answer

It looks like you are dividing by 0. This will output as "null" in Alteryx, and you will get a warning. You can fix this by adding an IF statement to all of your formulae, or you can Data cleanse to replace all "null" with "0". Not sure if you are having any more problems since it looks like all non-zero values are being properly captured.

moshood · Answer

please see attached .

i have noticed that some figures are not pulling through at all

Deano478 · Answer

@moshood what is the expression you are using to do this calculation?