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

Question

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.

Test - Input Values.xlsx

Output Test File.xlsx

Holdings Test File.yxmd

messi007 · Accepted Answer

@ll98,

Please see attached the updated workflow.

Hope that helps!

Regards,