Thank you! This seems to work for the most part. My upper bound on the total amount, however, seems to be only around $4K, when I have individual invoices much higher than this. Going back to the String Manipulation node, I think what’s happening is that the numbers that are already in the Long format are getting truncated out (I changed from toInt to toLon).
I will keep diagnosing, but wanted to let you know in case you might know why this is happening.
Here’s a sample dataset. Generating random numbers inherently generates mostly unique/distinct numbers, but I went through and replicated some of the random numbers such that we can have more than 1 invoice per customer.
So it looks like the dates are already in date format, and the amount is already in integer, so you don’t need to do any manipulation for these 2 columns. Removing these 2 nodes, the new workflow using your Excel file looks like this: