What's the deal with milliunits ?

Ok, i've finally figured out how to use the API to automatically import YNAB transactions into Excel. I've just noticed that amounts are in milliunits? Never heard of that prior to doing this (not a programmer by any stretch). I'm trying to convert the amount into normal dollars and cents but it seems that milliunits display differently based on whether or not the number is negative vs positive.

Can anyone tell me how I can convert milliunits into $s for positive and negative numbers?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Nevermind I figured it out

    • Hi Magenta Piranha !

      I'm happy you were able to figure things out! Would you mind sharing what you did to correct this issue, for anyone else who stumbles upon this thread? It may be a huge help to someone else in the future! :)

  • 1. Added custom column in PowerQuery to multiply "amount" by 1000

    2. Split the "amount" column in to 2 customer columns (Inflows and Outflows) in Excel's PowerQuery.

    3. Transformed the "Ouflows" to that it displayed absolute values

    4. Added custom column in excel pivot table to calculate the value I was looking for (formula to change outflow back to negative number)

Like Follow
  • 8 mths agoLast active
  • 3Replies
  • 126Views
  • 2 Following