Hi!

I need to generate a report calculating the amount needed for each resource used in procedures, based on the number of students in a number of courses where these procedures are performed.

My data structure is similar to this:

But I’m having a hard time finding a way to multiply the quantity of each resource by the number of students in the respective course and then sum them up to generate the report.

I was trying to solve it by generating nested or a sequence of repeating groups, but I couldn’t access data from higher levels and also couldn’t consolidate multiple items in deeper levels.

Is there a smarter way to solve it?

Thanks guys!