Percentages

[Samad_AC]

Hi fellow Alteryx users!

I'm a new learner to nAlteryx and I am still learning how to use software,

I however, have an issue.

I have a spreadsheet that contains columns such as Name, In Prep (In precentages) and Completed (In percentages).

I'm just trying to get those three columns together (Which I sorta know how to do).

However, everytime I get a 'NULL' written in the tabs which have a zero percentage in them, is there a way I can take out the NULL and just make it out to be a zero? I'm hoping to make a Tableu graph out of the data from Alteryx hence why I kinda need the 'NULL' feature out.

Thank you in advance and I hope to hear from you.

Kind regards.

[RolandSchubert · Accepted solution]

Hi @Samad_AC ,

you can use the DataCleansing tool to achieve this. Simply connect it to the Input tool, the default option is to replace NULL by 0 for numeric fields. Do this solve your problem?

Best regards

Roland

[DiganP · Accepted solution]

@Samad_AC I would use the data cleansing tool then the formula tool to concatenate the columns together. It would look something like this.

[Field1]+[Field2]+[Field3]

If you can provide a specific sample dataset, I can share the results with you.

[Samad_AC]

Thanks a lot, will share a data set tomorrow. 

Appreciate the help.

Kind regards

SC

[Samad_AC]

Thank you so much, it works now and looks much smoother. 

Kind regards

SC