E-Notation to Numeric conversion (Output)

[Sasthana25]

Hi, 

I have build a workflow where I am getting the no. generated in exponential format when I output(export it)- refer below table please:

ABC	29679193061	-30538883530
YUO	2.42422E+11	-2.4874E+11
NHG	9876928070	-9745391035
DFK	5.70141E+11	-5.57734E+11
2 Day ccy	8.52119E+11	-8.46758E+11
Total	1.26125E+12	-1.26084E+12

Currently all the attributes for this calculation is in doubles - how can i get it into proper numeric format like below.

ABC	29679193060.66	-30538883529.53
YUO	242421917966.75	-248740210484.65
NHG	9876928069.72	-9745391034.73
DFK	570140627445.62	-557733924003.99
2 Day ccy	852118666542.74	-846758409052.90
Total	1261249138616.64	-1260835136254.78

Any help is much appreciated. 

Thanks,
Swati

[DawnDuong · Accepted solution]

hi @Sasthana25 

One way is to use the ToNumber function

E.g. 

ToNumber("4.256411411E9") returns the string 4256411411 as a number.

For full details see this link: https://help.alteryx.com/20213/designer/conversion-functions

Dawn.

[Sasthana25]

Thank you so much @DawnDuong. I have tried to use the same as suggest however, when its exported by output to .xlsx I am still getting the values in E-notation.

Similarly, I have few logics with percentage calculation, which is again coming in E-notation:

A	B	C
% 4 day ccy	4.10E-02	3.94E-02

B and C needs to be in % - Is there a way to handle these and also get % symbol? 

Thanks,
Swati

[DawnDuong]

hi @Sasthana25 

as long as before you export to excel the numbers are converted to proper numbers then Excel will read them as numeric.

The reason why when viewed excel, the data appears as scientific format can be because of Excel auto formatting, not because of Alteryx. You can check this by clicking on the Excel field and see whether the data is a number or a text string. If it is already in numeric format, it's a matter of excel formatting.

If you want the output to have fixed format, one method is to use the Reporting Tool. I am not an expert in Reporting Tool though... 

If you want your format to be fixed in % and presented as a string, one way is to use the tostring function (https://help.alteryx.com/designer-cloud/conversion-functions )

hope this helps you.
Dawn.