I can’ seem to figure this out. Input is as follows:
I want to create the following output:
Total_Qty_DueDate A = 30
Total_Qty_DueDate B = 5
I have tried the Numeric Aggregator but it’s not Summing by DueDate. Any ideas? Thanks again!
Thank you so much for your reply. I have never used Map and Sum together!
However, to solve my problem, I needed to set the GroupBy field in the Aggregator correctly!!
Now it groups all the qtys by Date and I can use the numeric agg on them!
Anyway all good now! Thanks
Hello there @Nick_B
I’m just stepping in to say congrats on getting this up and running
Also, thanks a lot for remembering to circle back to the community and for sharing what did the trick for you. This is super valuable stuff and has the potential to help many folks looking for similar information in the future.
Just FYI: I marked your comment as a solution to keep the community organized and easy to search for answers