Versions Compared

Old Version 3

changes.mady.by.user Raymond van Pruijssen

Saved on

compared with

New Version 4

changes.mady.by.user Alex Post

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagepy
a = str(u.GEMIDDELDE.ALS(Veld!Dossieritem.ID,Veld!OK_RIJ.ID,">2"))
b = str(u.GEMIDDELDE.ALS(Veld!Dossieritem.ID,Veld!OK_RIJ.ID,"<2"))
c = str(u.GEMIDDELDE.ALS(Veld!Dossieritem.ID,Veld!OK_RIJ.ID,"<=2"))
d = str(u.GEMIDDELDE.ALS(Veld!Dossieritem.ID,Veld!OK_RIJ.ID,">=2"))
e = str(u.GEMIDDELDE.ALS(Veld!OK_RIJ.ID,Veld!Datum.ID,">=" + str({Datum})))
f = str(u.GEMIDDELDE.ALS(Veld!OK_RIJ.ID,Veld!Datum.ID,">=12/14/2016"))

Uitleg voorbeeld a = str(u.GEMIDDELDE.ALS(Veld!Dossieritem.ID,Veld!OK_RIJ.ID,">2"))
Berekent het gemiddelde van alle waardes van de kolom Dossieritem(Veld!Dossieritem.ID), waar de waarde van kolom OK_RIJ(Veld!OK_RIJ.ID) groter is dan 2.