E-Notation to Numeric conversion (Output)

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

Output

Accepted answers

DawnDuong

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.

All comments

DawnDuong

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335