Hi WF Fusion Community,
Sorry for posting this twice - I posted in the regular WF community, and then realized this specific Fusion community exits
I'm looking to get the sum value from a specific custom field (Amount__c) based off of one or many bundles, per program.
Example:
- There 2 Billing Records over in Salesforce associated to WF Program A. I grab this data with a Salesforce (search with query) module. See screenshot called "Get Billed Overage from SFDC".
- It pulls over the Amount field value from those Billing Records. In this example, let's say the Amount value for Billing Record #1 is 114,000, and the Amount for Billing Record #2 is 4,500. See screenshot A, attached.
- Then, I have an Iterator module that looks at the Billing Records from the above Salesforce module (search with query), and groups bundles by Salesforce Asset ID (an asset has a 1-1 relationship with a program). See attached screenshots called "Iterator" and "Iterator Results".
- From there, it hits a numeric aggregator module. See attached screenshot called "Numeric Aggregator". This is where my issue has occurred. See screenshot called "Numeric Aggregator Results". You'll see that the two input bundles are just duplicating the first value from bundle one on the iterator module. I was expecting it to sum the Amount values from both bundles on the iteratori module.
Does anyone know what my issue might be?
Thanks!
Nick