Numbers of hours

[Roman_Lojek]

Hi.  From couple of days I am trying to count duration time.

I want to calculate how many hours did somebody worked last month.

I am using filtr table to filter date.

I tried sum(select.....), but it gives me all the hours in the selected table. 

I want to have just the hours between two dates.

My formula  This is the source tableThis is filter table

[Marc_Dillon]

What is the exact sum(select( that you tried, and where are you trying it from?

[Roman_Lojek]

I have tried something like that from the filter table. It is strange because the filter goes right. But when I tried to filter the exact sum it made a summarisation of all the events from the range of "Gminy"

Select(Sierakowice[ID],AND(
IF(ISNOTBLANK([StartDate]),
[Data]>=[_THISROW].[StartDate],true),
IF(ISNOTBLANK([To Date]),
[Data]<=[_THISROW].[To Date],true),
IF(ISNOTBLANK([Klient]),[Gmina]=[_THISROW].[Klient],true)))

[Marc_Dillon]

You're missing [_THISROW]s in your ISNOTBLANK()s.

[Roman_Lojek]

You are right Marc.

[Roman_Lojek]

Now when I want to make a pdf doc. with the :<<SUM(select(SIERAKOWICE[warsztaty], AND(([data]>=[_thisrow].[startdate]),([data]<=[_thisrow].[To Date])))),>>. formula to get the sum of the duration from the selected rows it shows me the result of all the Klient's . What I am doing wrong?

It should have about 12,45 not 21,45

[Marc_Dillon]

Did you forget to include the client condition in that expression? You have it in your previous expressions.