0

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

null
    • John_Halls
    • 2 yrs ago
    • Reported - view

    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

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    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

    • John_Halls
    • 2 yrs ago
    • Reported - view

    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 
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    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.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    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

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    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.

    • John_Halls
    • 2 yrs ago
    • Reported - view

    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

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    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

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    If I keep the hours earned for each week I can create the curve  S for the Project 

    • Fred
    • 2 yrs ago
    • Reported - view

    Hi Rafael -

    Do you have 52 week fields?

    or

    Just 9 through 15 that you show in the picture?

    • John_Halls
    • 2 yrs ago
    • Reported - view

    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

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    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 

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    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