Sum Aggregate count only a in if condition

[#1]

Hi to all,
I need to sum aggregate and count only if the data satisfied a kind of conditions..

I tried all the combinations but the sintax is not correct....

sum(if(Type_doc='BL', aggr(count(distinct SC)),Store,Month, Day))

any ideas ?

thx
Andrea

[#2]

Hi Found the right sintax

=sum( aggr( count(distinct if(Type_doc='BL', SC)),Store,Month, Day))

Bye

Andrea