Help with Set Analysis

[eduardo_dimperio]

Hi !

Im trying to count the OID_METER when CONSUMO_TOTAL > 1,5* CONSUMO_ESPERADO, but i can relate two dimensions.

How can i do this?

Count({<CONSUMO_TOTAL = {">1.5* CONSUMO_ESPERADO"}>} OID_METER) ???

[sunny_talwar · Accepted solution]

May be this

Count({<OID_METER = {"=CONSUMO_TOTAL > (1.5* CONSUMO_ESPERADO)"}>} OID_METER)

[eduardo_dimperio]

Hi Sunny ! How Long.

It works perfectly

May i ask you another think related?

If i want in that selection, only CONSUMO_TOTAL > 5. How can i do that, because will be 2 selection for the same Count(Meter)?

Maybe

Count({<OID_METER = {"=CONSUMO_TOTAL > (1.5* CONSUMO_ESPERADO)"}, {"=CONSUMO_TOTAL > 2"}>} OID_METER) ?

[sunny_talwar]

May be this

Count({<OID_METER = {"=CONSUMO_TOTAL > (1.5* CONSUMO_ESPERADO) and CONSUMO_TOTAL > 2"}>} OID_METER)

[eduardo_dimperio]

Thank You !