Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Formula Creation - If value shows as Null -- i want to replace it with 0.00%

ll98
9 - Comet
‎06-13-2021 07:43 PM

Hi Alteryx Family

 

I have the following WF -- but I need to change the value that its presented after it complete.  For example if there's no value give -- I'll will like to show as 0.00%  instead of %.

 

ll98_0-1623638280753.png

Attached is the input file as well as how the file should look like at the end. 

Preview file
17 KB
Preview file
11 KB
Holdings Test File.yxmd
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
DawnDuong
13 - Pulsar
13 - Pulsar
‎06-13-2021 10:28 PM

Have you try to use a Data Cleansing tool. One option allows you to replace all null value with zero. Formatting to 0.00% can be done in Excel.

Reply
messi007
15 - Aurora
15 - Aurora
‎06-13-2021 11:59 PM

@ll98,

 

Please see attached the updated workflow.

 

messi007_0-1623653945336.png

 

Hope that helps!

Regards,

 

Holdings Test File.yxmd
Reply
0 Likes
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels