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
-
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.
Content aside
- 2 yrs agoLast active
- 6Replies
- 56Views
-
2
Following