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?