REF_ROWS and grouping

[tmigliorini]

Good morning

I have two tables: Invoices and customers

Customers table is like

- Customer ID (key)

- REF_ROWS to Invoice table

In Invoice tabel I got 2 invoices on this customer

- Invoice ID

-Invoice Amount (in €)

- Customer ID (parent table)

When Igo to detail view of the customer's table I can see the full list, but an automated grouping on the heading is created counting how many invoices I got for that customers.

How can I get the SUM of the amounts instead?

Thank you

[Marc_Dillon]

In the emulator, click the "View" text under the inline table view. This opens that view "fullscreen", which allows you to follow the blue link underneath the emulator to easily get to that view's config. Then change the group aggregate setting.

[tmigliorini]

I tried but there is no grouping option

[Dan_Oliphant]

There is no grouping for detail view.  I believe you would have to go to the inline view of the REF ROW table.  You will be able to change it to SUM instead of COUNT

[tmigliorini]

By doing this, I can't change what I wish to

[Marc_Dillon]

You missed a step, click here first:

[tmigliorini]

Still not working, see my image reply to Dan_Oliphant