Conceptually not too difficult. used the information in the post about file formats as a lookup. Had a few issues with running my batch macro. I think because I lacked a tool following it, it was only running for the initial record to save disk space. Either way when I put tools to follow it (browse then the tools to sum the value fields) it took a while to run but seemingly calculated correctly.
![Challenge 180 WF Image.png Challenge 180 WF Image.png](https://community.alteryx.com/t5/image/serverpage/image-id/319177iF023ACDE3505C0C5/image-size/large?v=v2&px=999)