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?
Solved! Go to Solution.
HI,
that's usually happens when the field type is Double and sometimes the summarize tool turns the field in double. Just connect right after a select tool and choose fixed decimal again as data type.
That did it, Thanks!