Forum Discussion

Frequent Visitor

3 years ago

Calculate the different hours between two tables

Hi @everyone, I am trying to calculate the different hours between two tables but it's not working, what should I do in this case? Table 2: Table 1: When I typed the formula b...

Frequent Visitor

3 years ago

I already created the relationship "Many-to-Many" between two tables and I tried to using this formula but it didnt work. I want to describe in details two reports as the following:

+ Table 1 ( Hour report): each ID displayed the total hours for which operated everyday. Some IDs will repeat or they are added or removed depend on the business situation.

+ Table 2 ( Results): each ID displayed the total hours that customer spent everyday.

For example: On 19/01/2019, ID: BJ-01-01, Table 1 (Hour) = 21.37, Table 2 (Results) = 8.15

And the result I want to show: