Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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