0

Formula diferent result

Fred

Hi the Cantidad Doc in the Formula is not the same on Table and Form 馃槸

if Clase = "Actividad" then
    cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.Clase = "Actividad")
else
    if Clase = "Documento" then
        cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.Clase = "Documento")
    else
        if Clase = "Plano" then
            cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.Clase = "Plano")
        end
    end
end

7replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    if you click on the refresh button (above the Id number in Table view) does it change?

    Like
    • Fred 馃槃, just at the same time.馃槈

      Like
  • Is Clase a formula?

    The code can be shortened, Can you try this plz :

    let cla := text(Clase);
    cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.Clase = cla)
    
    Like
      • Rafael
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

      RoSoft_Steven Rooryck 

      Fred

      Thanks again guys excelent suport.

      Like 1
    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 mths ago
    • Reported - view

    RoSoft_Steven Rooryck

    Hi again Steven I have the same problem with these Formula work in Form but not in Table

    cnt(select DOCUMENTOS where 'Ganado REAL' = 30)

    Count the Documents where Ganado REAL is 30

    I have six Formula witn null,30,50,70,100

    Like
    • Rafael 

      'Ganado REAL'  is a formula field that displays % so you could use this:

      cnt(select DOCUMENTOS where number('Ganado REAL') = 30)

      Hope this helps.

      Like
      • Rafael
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 mths ago
      • Reported - view

      RoSoft_Steven Rooryck Thanks again. 馃憤

      Like
Like Follow
  • Status Answered
  • 2 mths agoLast active
  • 7Replies
  • 32Views
  • 3 Following