0

Formula needed:

Hi I need a Formula to find the different between the 'Horas Ganadas Real' for each week Example w37 5024.30 - w36 4660.10 = 364.2 for each week 

6 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    Can you post the code that you have written so far?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred I have nothing Fred, The head does not give for more

    • Fred
    • 1 yr ago
    • Reported - view

    Would you like me to post a possible solution or would you like my help in figuring out a solution?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred Hi Fred I will like a solution, if is possible and is not problem for you.

    • Fred
    • 1 yr ago
    • Reported - view

    Here is one solution:

    let t := this;
    let x := first((select AVANCES_PROYECTO)[Semana = t.Semana - 1]);
    'Horas Ganadas Real' - x.'Horas Ganadas Real'
    

    It will give you a blank for the first record and it doesn't account for if you have multiple records with the same Semana.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred  Very grateful Fred, Works perfect 👍this really never end, something new always comes our, and some improvements, it's total crazy.

Content aside

  • 1 yr agoLast active
  • 6Replies
  • 56Views
  • 2 Following