Put Value Number after Formula
How can I put Value Number after these Formula
The problem I have is that my field Semana change evelyn week and I need mantein the value for each week.
let x := (select Documentos where Semana = 9);
sum(x.'Horas Ganadas Plan')
Thanks appreciate help
13 replies
-
Check out the functions week(date), yearweek(date) and today().
let x := (select Documentos where Semana = week(today())); sum(x.'Horas Ganadas Plan')
Regards John
-
Hi John thanks but don't work, I need cutoff every friday, I have I field Semana that every week change from 9 to 10 to 11 .......
The Formula works
let x := (select Documentos where Semana = 9);
sum(x.'Horas Ganadas Plan')Example for week 9 place 144 is ok but for week 10 sum the 9 and 10 366 and week 9 place 0
I have 52 weeks field
But I need the value number for each week from the sum(x.'Horas Ganadas Plan')
I hope explain good
Thanks
-
Hi Rafael
Could you explain this part for me.
Rafael Sanchis said:
Example for week 9 place 144 is ok but for week 10 sum the 9 and 10 366 and week 9 place 0 -
Hi John where I cutoff date in week 9 I earned some hours in my case 144 hours my next cutoff date 10 I earned 200 hours more in each week earned hours I need to maintein these hours by each week but the Formula sum the week 10 344 and 0 in the week 9.
I cutoff every friday and the Project have 22 week, I need earned hours for each week to create the S Curve.
-
Ok in that views I earned 144 hours in week 9 in week 10 earned 200 but sum week 9 and 10
I need sum each week
-
I have a DataDate that I change every friday for calculate the earned value hours the problem I have is that the when calculate for semana 9 is ok but when calculate for semana 10 sum botón week that I need is sum week by week.
-
Hi Rafael
As I understand it, you have a field for each week. Could you let me have a copy of the formula you are using for Semena 9, and also for Semena 10.
Thanks, John
-
For week 9
let x := (select Documentos where Semana = 9);
sum(x.'Horas Ganadas Plan')For week 10
let x := (select Documentos where Semana = 10);
sum(x.'Horas Ganadas Plan')Some difficult explain in my bad english
-
If I keep the hours earned for each week I can create the curve S for the Project
-
Hi Rafael -
Do you have 52 week fields?
or
Just 9 through 15 that you show in the picture?
-
Hi Rafael
Not quite sure why this isn't working. It's odd how it's adding 9 and 10 together. Put this in a view so that you can see which records are being added together.
select Documentos where Semana = 10
Regards John
-
Complex yes, First I have the week that I need for Project for now I work with 15 weeks
Not working because I change the datadate every week and I have a field week(DataDate) that gives me the week.and the week change every week.
Thanks
-
These picture saw DataDate 4 Mar week 9 and Horas Ganadas Plan 144
The second pinture saw DataDate 11 Mar week 10 and Horas Ganadas Plan 200
Content aside
- 2 yrs agoLast active
- 13Replies
- 103Views
-
3
Following