Using Total in a child table embedded in a form
I have a form (based on a parent table) with 3 embedded reports (based on the same child table).
The children reports are the same except that they have one different filter each.
I need the Total of a column to calculate another column (class % in my picture).
If I use the summary field in the parent table, it gives the total of the all three tables. (See first picture)
I also tried with the report formula but I have the same issue.
Do that Total field have a name that we can re-use in the formula ?
You will find attached some pictures of my form for your understanding
If I understand your problem correctly, I think you can create a new summary field that is filtered the same way as your child report. For example, summary of quantity with filter grinding media type = balls.
