Forum Discussion

JPortal's avatar
JPortal
Qrew Member
2 days ago
Solved

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

 

reports
  • Denin's avatar
    Denin
    2 days ago

    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.

2 Replies

  • JPortal's avatar
    JPortal
    Qrew Member
    2 days ago

    **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.

  • Denin's avatar
    Denin
    Qrew Cadet
    2 days ago

    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.