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?
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)