Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have in my database a numeric column, but I need to make avg without taking into account records with value 0.
I'm showing the avg result in a text object , but It takes into count the values =0 and the result varies greatly from what I expect.
My expression in the text object is:
And my BD is:
thanks for your help.
Or (assuming you want to consider user selections) use the intersection operator *
=Avg({<PREGUNTA615_24 *= {">0"}>} PREGUNTA615_24)
or
=Avg({<PREGUNTA615_24 -= {0.00}>} PREGUNTA615_24)
or not using set analysis
=Avg( If(PREGUNTA615_24 <> 0, PREGUNTA615_24))
Try this:
Avg({<PREGUNTA615_24 = {'>0'}>}PREGUNTA615_24)
Or (assuming you want to consider user selections) use the intersection operator *
=Avg({<PREGUNTA615_24 *= {">0"}>} PREGUNTA615_24)
or
=Avg({<PREGUNTA615_24 -= {0.00}>} PREGUNTA615_24)
or not using set analysis
=Avg( If(PREGUNTA615_24 <> 0, PREGUNTA615_24))
And once again.
Man I have to be more descriptive in my responses and cover all possibilities. I am getting there