In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Enter zero in multiple columns

MB_Rocks
7 - Meteor

Hi 

 

Can someone help in inserting zero in multiple columns. I'm using multi field formula but its not happening.

 

Problem statement:

Where ever column in null/blank need to add zero where ever have values need to remain as it 

 

Here I have attached a dummy sheet as well .Please help 

3 REPLIES 3
JarekSkudrzyk
11 - Bolide

@MB_Rocks 

Hi,

please find the solution attached. If this solves your problem please consider marking my answer as a solution.

JarekSkudrzyk_0-1647895216123.png

 

 

regards

MB_Rocks
7 - Meteor

@JarekSkudrzyk Thanks a lot 

JarekSkudrzyk
11 - Bolide

@MB_Rocks you are welcome!

Labels
Top Solution Authors