Using Total in a child table embedded in a form

Question

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

Denin · Accepted Answer

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.

JPortal · Answer

**bleep**, you make me feel like the rookie I am. Thank you so much. There are some old discussions about this topic. Hope they found their way.

Sign up

Login to the community