0

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

2 replies

null
    • John_Halls
    • 2 yrs agoTue, March 22, 2022 at 3:17 PM UTC
    • 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 agoTue, March 22, 2022 at 3:29 PM UTC
    • Reported - view

    Works, thanks a lot John Halls

Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • 2 yrs agoTue, March 22, 2022 at 3:29 PM UTCLast active
  • 2Replies
  • 35Views
  • 2 Following