0

Need cnt script

Need cnt in '<_Partidos1'  (reationship with games) how many games have 3  'Ptos L' in this example 2 

cnt('<_Partidos1' where 'Ptos L' = 3)

This not work

6 Antworten

null
    • Kruna
    • vor 8 MonatenSun, September 22, 2024 at 1:19 PM UTC
    • Gemeldet - anzeigen

    Hola Rafael, which table is it?

      • Rafael_Sanchis
      • vor 8 MonatenSun, September 22, 2024 at 2:23 PM UTC
      • Gemeldet - anzeigen

       

      The table is Equipos. 

      • Kruna
      • vor 8 MonatenSun, September 22, 2024 at 2:40 PM UTC
      • Gemeldet - anzeigen

      maybe this works?

      cnt(select Partidos where 'Ptos L' = 3)
      • Rafael_Sanchis
      • vor 8 MonatenSun, September 22, 2024 at 2:55 PM UTC
      • Gemeldet - anzeigen

       

      Hi again

      Need cnt only by each teams.

      In this case the cnt 2 

      Table Equipos. Tab Local__Visitante

       

      La Liga 24_25.ninox
      • Kruna
      • vor 8 MonatenSun, September 22, 2024 at 3:34 PM UTC
      • Gemeldet - anzeigen

      I guess this should work ?

      cnt('<_Partidos1'['Ptos L' = 3])
      • Rafael_Sanchis
      • vor 8 MonatenSun, September 22, 2024 at 3:46 PM UTC
      • Gemeldet - anzeigen

       

      Thanks Kruna 

Anmelden, um zu antworten

Content aside

  • Status Answered
  • vor 8 MonatenSun, September 22, 2024 at 3:46 PM UTCZuletzt aktiv
  • 6Antworten
  • 28Ansichten
  • 2 Folge bereits