Count expression with if

[#1]

Hy guys!

I need a help to resolve a little problem with my count expression...

i have a field (Numbers of interventions) and i need to count this field only if the sum of hours of interventions are > 20.

I try to do the expression...but it doesn't work...

sum(if(sum(aggr(sum(VAL_SKP), COD_PDR))>20,1,0))

Thank you for help!!!!

[swuehl]

Maybe like

=sum( aggr( if( sum(VAL_SKP) > 20, 1,0), COD_PDR))

but I am pretty unsure what you need here. Could you upload a small sample application?

[rustyfishbones]

You could try

SUM({<VAL_SKP ={">20"}>}COD_PDR)

[#4]

i have a table like the first two column...

the point is that i need to sum 1 only if is verified the condition sum(aggr(sum(val_skp),cod_pdr))>20...if this condition is ok then i sum 1, else 0. condition works well but the "then" instruction doesn't work. it is because there are sum operator outside and inside if instructions. Have u got some suggestions?

thx a lot

COD_PDR	VAL_SKP	SUM(ORE_PDR_INTER)
		60,54
31761701	0,38	0,76
34112001	0,5	2
31952801	0,54	1,08
31952802	0,54	1,08
32317701	1,54	3,08
34651403	1,54	3,08
31716701	0,42	0,84
34636601	0,42	0,84
35720301	1,67	6,68
34299101	0,54	1,08
34335102	0,54	1,08
33040301	1,54	3,08
50034301	1,54	3,08
50037201	1,54	3,08
33022401	0,54	1,08
31290401	0,27	0,54
31290402	0,27	0,54
34561402	0,27	0,54
34572602	0,27	0,54
34572902	0,27	0,54
34573505	0,27	0,54
32708501	0,5	1