How to calculate two fileds in two different tables and match ID by name?

1

I have two different tables

Table 1 (table view)
resource name(korean), total working hour(given), remained working hour(calculated by two fields in different tables)

Table 2 (calendar view)
Resource name(korean), daily working hour, place, etc.

expected result
I want to get total for; working hour(table1) - daily working hour(table2), matched by resource name in two different tables. I want to show this result in table1 " remained working hour".

I’ve tried many different ways but no luck yet!

Question two

When I try to get output for table on CALENDAR TITLE as a formula; thisrow.resource name, thisrow.workinghour as a title of a calendar, how can I express it without error? It is difficult to set two text value at the same time. returned error~ :slight_smile:

Thank you for your support!

2

HI Joshua,

Welcome to the community!

It is always helpful if you could supply an example doc, so it is clear what you are trying to do.

Regards
Piet

3

Thank you for your reply, here it is~ It’s all Korean I’m on translation now

4

The formula for Remained Hours would be something like…

thisRow.[Total working hours] - [View of 근무표].Filter([근무자]=thisRow.[이름]).Sum()
5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.