So the issue was that my prior year was not closed yet, so I had both the current and next year open. I'm not sure why that should be an issue but I was able to close my prior year and now the formula is picking up all posted transactions. For whatever reason TOTPOST does not include "next year" transactions even though they have been posted.