Hellow Alteryx Community - I use the Summarize tool to average exchange rates on a quarterly basis but have found that if there are rates with four or five "0" after the decimal point, such as 0.000033 the average appears as scientific notation - in this case it would be 3.3e-05. I attached a workflow with examples. I can work around it by doing a sum of the rate and dividing it by the count but I would rather not. I have tried different field types and different average options within the Summarize tools but the silly thing is determined to resist. Any suggestions?
