How to Aggregate Nested Iterator Results to Single Program-Level Value? | Community
Skip to main content
Level 9
November 12, 2025
Solved

How to Aggregate Nested Iterator Results to Single Program-Level Value?

  • November 12, 2025
  • 1 reply
  • 144 views

Hi Fusion Community!

 

Wondering if anyone can help with the following challenge?

 

Issue: I'm building a Fusion scenario to calculate a program-level metric that requires aggregating data across multiple nested iterators: Program → Projects → Tasks → Assignments.

 

Current Flow:

  1. Get Program details
  2. Iterator: Loop through all Projects under Program
  3. Iterator: Loop through all Tasks per Project
  4. Iterator: Loop through all Assignments per Task
  5. Calculate cost per assignment: (User Cost Rate * Planned Hours) / 60
  6. PROBLEM: Need to sum ALL assignment costs into ONE program-level value

Expected Result: One bundle with total cost = sum of all assignments across all tasks across all projects

 

Actual Result: Multiple bundles/operations, each with a subset of the total

 

Question: How do I aggregate across multiple nested iterators to produce a single output value at the program level? Is there a specific aggregator configuration or module placement that works for this nested scenario?

 

Any guidance is appreciated!

Thanks!
Nick

Best answer by IvanBebek-iX

Hi @nickva7 ,

 

Could you please take a screenshot of the final numeric aggregator, I would assume you are aggregating per "Iterate through assignments" and as you have three outputs it aggregates for each, if you want to aggregate per program you would have to set the aggregation module to be "Iterate through programs" or if you want to aggregate per project as you wrote you can set the aggregation module "Iterate through projects".

 

Could you please try this and let me know how/if it works? Thank you in advance.

 

Best regards,
Ivan

1 reply

NickVa7Author
Level 9
November 12, 2025

Screenshot:

 

 

IvanBebek-iX
IvanBebek-iXAccepted solution
Level 5
November 13, 2025

Hi @nickva7 ,

 

Could you please take a screenshot of the final numeric aggregator, I would assume you are aggregating per "Iterate through assignments" and as you have three outputs it aggregates for each, if you want to aggregate per program you would have to set the aggregation module to be "Iterate through programs" or if you want to aggregate per project as you wrote you can set the aggregation module "Iterate through projects".

 

Could you please try this and let me know how/if it works? Thank you in advance.

 

Best regards,
Ivan

NickVa7Author
Level 9
November 13, 2025

Yes!  That was it, @ivanbebek-ix !  Good catch.  Thank you.