Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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.
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 |
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 |
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)