Forum Discussion
Etherscan api
Anyone here with experience using the Etherscan api? I'm having some challenge with transaction values.
The api is dumping decimal numbers into pbi as integers and I'm not sure how to either correctly pull or a way to clean the data.
etherscan
pbi
Great, that got me thinking on the right path, thank you! What I did was:
1- extract the first four digits from "value" column
2- count the characters in "value" column
3-divide first four digit column with a calculated column using IFs based on the character count to divide by 1xxxx (x being 0)
5 Replies
abujouz86 oh so you are getting scientific notation value, so it is converting to decimal correclty.
Scientific notation calculator - with step by step explanations (mathportal.org)
Great, that got me thinking on the right path, thank you! What I did was:
1- extract the first four digits from "value" column
2- count the characters in "value" column
3-divide first four digit column with a calculated column using IFs based on the character count to divide by 1xxxx (x being 0)
Yes, shown in power query. Changing to decimal number data type didn't work and is not correct
value
2.05E+16 1E+18 change decimal from auto to 0
value
20500000000000000 1000000000000000000
