Requesting help why Alteryx is giving out blank values

Question

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?

ABCCalculated manuallyAlteryx output-8305695663102569023232.0720536932.0721-93620036023852682829832.650666132.6507-8723392-4298082664032734.3584371234.3584-85527421416022469384334.0616889834.0617-82476502749732463296232.3658884432.3659-39897613 24454386716.31511495 -46759057 24976644618.72111236 -42970894 24377400517.62734874 -12164482 2512332994.841906725 -156998 2901822620.054103238

pedrodrfaria · Answer

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.

afv2688 · Answer

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