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
What is the exact sum(select( that you tried, and where are you trying it from?
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)))
You're missing [_THISROW]s in your ISNOTBLANK()s.
You are right Marc.
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
Did you forget to include the client condition in that expression? You have it in your previous expressions.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |