Hello, I have a querry with this calculated field :
Expr1: DCont("[hta]","Pacientes antecedentes totales","[HTA]='1' ")/DCont("[HTA]","Pacientes antecedentes totales")*100
It is a percentage of value 1 over the total registers with a value for HTA.
If I apply a criteria in a diferent field (i.e age , gender) the results remains over all the registers with a value in field HTA , instead of a limited number of registers by other criteria .
So I can't see this results for any kind of limited registers in the same querry.
Can you help me ?
Thank you very much!
Querry
Expr1: DCont("[hta]","Pacientes antecedentes totales","[HTA]='1' ")/DCont("[HTA]","Pacientes antecedentes totales")*100
It is a percentage of value 1 over the total registers with a value for HTA.
If I apply a criteria in a diferent field (i.e age , gender) the results remains over all the registers with a value in field HTA , instead of a limited number of registers by other criteria .
So I can't see this results for any kind of limited registers in the same querry.
Can you help me ?
Thank you very much!
0 commentaires:
Enregistrer un commentaire