Requesting help why Alteryx is giving out blank values

[Manjari]

Hi All, 

The formula is very simple, -((A+B)/C)*100

The Alteryx output does not populate where B is empty. I see this as pattern through out the Alteryx output file. 

The data type of A, B, C and Alteryx output columns are double. what am I missing?

A	B	C	Calculated manually	Alteryx output
-8305695	66310	25690232	32.07205369	32.0721
-9362003	602385	26828298	32.6506661	32.6507
-8723392	-429808	26640327	34.35843712	34.3584
-8552742	141602	24693843	34.06168898	34.0617
-8247650	274973	24632962	32.36588844	32.3659
-39897613		244543867	16.31511495
-46759057		249766446	18.72111236
-42970894		243774005	17.62734874
-12164482		251233299	4.841906725
-156998		290182262	0.054103238

[afv2688]

Hello @Manjari ,

When you want to do an operation with a null value alteryx doesnt perform any calculations, therefore it does not assign to the corresponding cell a value at all, skipping that cell.

If you want alteryx to assign a value to the empty cells I would recommend you to use before a data cleansing tool or an if condition, like

IF IsNull([B]) THEN -(([A])/[C])*100 ELSE -(([A]+[B])/[C])*100 ENDIF

Regards

[pedrodrfaria]

Hi @Manjari 

As @afv2688 explained, Alteryx will only do these calculations for correctly populated numeric fields (this excludes null and empty columns). 

Either change the function to the example right above or simply add a data cleansing before the formula (leave the config as default). Adding the data cleansing will transform the null data into 0, then Alteryx will do the calculation.

Pedro.