Formula don't give anything

These Formula don't give me anything, any idea.

let x := (select Documentos where Semana = 9);
if Week = (select Documentos).Semana then
sum(x.'Horas Ganadas Plan')
end

Thanks

- John_Halls
- 2 yrs ago
- Reported - view
Hi Rafael

This line will never be true

if Week = (select Documentos).Semana then

Because Week is a number (or text) and (select Documentos).Semana returns an array, even if there is just one element in the array.

If you want the sum of 'Horas Ganadas Plan' for week 9 then this can be done in one line

sum((select Documentos where Semana = 9).'Horas Ganadas Plan')

Regards John
- Rafael Sanchis
- Rafael_Sanchis
- 2 yrs ago
- Reported - view
Works, thanks a lot John Halls

Content aside