Filter between two dates

[amigosos]

What's wrong?

NTrabajo	FechaFinReal2	sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)
		473586,824
DD-2001-A	21/11/1997	1,25
DP-0219-A	12/06/1998	8
DP-0416-A	31/12/1998	10
DP-0417-A	01/10/1998	1
DR-0096-A	15/06/1998	2
DR-0300-A	06/11/1998	4,5
ED-0011-A	18/01/1999	4,5
ED-0047-A	30/03/1999	2
ED-0146-A	17/12/1999	2,5
EP-0056-A	29/03/1999	0,75
EP-0280-A	24/01/2011	0,45
EP-0301-A	22/02/2000	10

Thanks

[johnw]

What numbers do you WANT to see?  Why?

What you MAY have expected was for the set analysis to override your dimension value.  It doesn't.  It INTERSECTS your dimension value.  If the dimension is in range, it'll use the dimension.  If not, you'll get null.  If you instead need to override your dimension value, you'd use the 'total' key word:

sum({<FechaFinReal2={">=01/01/2011 <=31/12/2011" }>} total Horas)

I have no idea if that's what you want, though.

[amigosos]

Thanks John,

I try to explain me. I want present a table with all "NTrabajos" (jobs), which "FechaFinReal2" (finaldate) is in 2011, and present  the "Horas" (dedications; hours) worked and each job.

For example:

NTrabajo	FechaFinReal2	sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)
		0,45
EP-0280-A	24/01/2011	0,45

[amigosos]

Thanks John,

I try to explain me. I want present a table with all "NTrabajos" (jobs), which "FechaFinReal2" (finaldate) is in 2011, and present  the "Horas" (dedications; hours) worked and each job.

For example:

NTrabajo	FechaFinReal2	sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)
		0,45
EP-0280-A	24/01/2011	0,45

[amigosos · Accepted solution]

I've found the error:

sum({<FechaFinReal2={">= 01/01/2011 <=31/12/2011" }>} Horas)

                                        Î this space is the error.

The correct form is:

sum({<FechaFinReal2={">=01/01/2011 <=31/12/2011" }>} Horas)