Hello all. Does anyone have any idea why the output pane would show formatting that does not match the format correctly shown in the formula results window? (see graphic)
Thank you,
Leroy
Thank you Joseph. Unfortunately, that alone did not remedy the problem. However, I did find a partial remedy here:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Formatting-number-with-commas-and-decimals/m-p/78553#M27523
Specifically, I used your formula and built a second one using: regex_replace([Total Funded 2019],"\d{1,3}(?=(\d{3})+(?!\d))","$&,")
After running the flow, it returned the exact formatting that I was looking for.
Thank you again for your assistance.
Hi @LeroyMagee are the results correct in the output file? Also does the result look different if you click on green anchor of the formula tool on the right hand side?
Hi Joseph. Yes, the results are correct. However, the formatting in the output pane isn't what's shown in the formula window. (i.e.: formula window indicates $ 1,000,000.00 but the output window shows 1000000.00 or $ 1000000.00 if I click the green anchor on the formula tool)
