Good Morning,
I am trying to figure out how I can retain my thousands separator and decimals when I convert to string. I have found using the multi-formula tool is super helpful, but if I convert before I do my if then statement the IF THEN will error out because its not numeric any longer. If I do it after I do the IF THEN formula (which is converted to string due to the nature of the formula) then that doesn't work either. I am at a loss, but for the contract work we are doing, I have to retain our commas, but they also want "*" in a numeric field because certain low numbers have to be suppressed. I cannot share my actual data due to confidentiality, but I created a very simple excel sheet that and Alteryx formula sort of showing what I need to do. I guess my question is can I do a "To String" in an "IF THEN".
