Simple Calculation Question: Total Sum of hours per CLIENT

[Sharifa]

Hi.🌍

I need to add number values in the 'hours' field per client. The client is identified by unique 'name' or 'Id'

I can do it either in a portal or in the layout itself.

Any tips her.

Thanks a bunch.

Edited June 9, 2022 by Sharifa

[comment]

Assuming you have a Clients table and a related Items table, you can use a calculation field defined in the Clients table as =

Sum ( Items::Hours )

Alternatively, you can define a summary field in the Items table as Total of Hours and place it on a layout of Clients. Or use it in a report produced from the Items table, sorted by Client.

 

19 minutes ago, Sharifa said:

The client is identified by unique 'name' or 'Id'

For purposes of relationship, the client should be identified by ID only - a unique and permanent value.

[Sharifa]

In the portal on the right side of the screen, You can see in last column field for hours worked 'Aantal_uren'. I need to calculate the total number of hours per record. 

 

[comment]

On 6/10/2022 at 12:05 AM, comment said:

you can use a calculation field defined in the Clients table as =

Sum ( Items::Hours )

Have you tried this?

 

On 6/10/2022 at 12:05 AM, comment said:

Alternatively, you can define a summary field in the Items table as Total of Hours and place it on a layout of Clients.

Have you tried this?

 

[Sharifa]

Yes. I changed the table reference and it worked.

Sum ( _TEST_CoastalCorners_Werkopdrachten_TABLE_DB::Aantal_uren )

Many thanks.