Forum Discussion
abujouz86
5 years agoHelper II
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 corr...
- 5 years ago
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)