SOLVED
Formula Creation - If value shows as Null -- i want to replace it with 0.00%
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ll98
9 - Comet
‎06-13-2021
07:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 %.
Attached is the input file as well as how the file should look like at the end.
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- Fuzzy Match
2 REPLIES 2
13 - Pulsar
‎06-13-2021
10:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
15 - Aurora
‎06-13-2021
11:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
