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 

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 11 days ago
    • Reported - view

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

    Like
      • Rafael
      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 days ago
      • Reported - view

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

      Like
    • Fred
    • Fred
    • 11 days ago
    • Reported - view

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

    Like
      • Rafael
      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 days ago
      • Reported - view

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

      Like
    • Fred
    • Fred
    • 11 days 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.

    Like 1
      • Rafael
      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 days 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.

      Like
Like Follow
  • 11 days agoLast active
  • 6Replies
  • 32Views
  • 2 Following