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
Can you post the code that you have written so far?
Would you like me to post a possible solution or would you like my help in figuring out a solution?
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.