Forum Discussion

abujouz86's avatar
abujouz86
Helper II
5 years ago
Solved

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...
  • abujouz86's avatar
    abujouz86
    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)