For some reason, I am getting added zeroes when converting into an excel file but my output from the workflow only has two decimal places
Hi @jpatel3868 ,
If you set the field to a type Fixed Decimal 19.2 (19 characters before the decimal, two after) then it will output from Alteryx with two decimal places.
If Excel renders this as 6 decimal places, then the problem is in excel not Alteryx.
You can test this by outputting to a .csv and opening in Notepad to show that it is outputting with two decimal places.
M
What if I want it in Excel only? How would I change the rendering to only up to two decimal places.
@jpatel3868 ,
Use the output tool to output into Excel?
I'm not sure I understand the question.
M.
