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

7 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

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

      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr ago
      • Reported - view

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

    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view

    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)
    
      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      RoSoft_Steven Rooryck 

      Fred

      Thanks again guys excelent suport.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr 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

      • Ninox partner
      • RoSoft_Steven.1
      • 1 yr ago
      • Reported - view

      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.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      RoSoft_Steven Rooryck Thanks again. 馃憤

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 7Replies
  • 49Views
  • 3 Following