count sum in set analysis

[anitamanders]

  Hello,

I want to count the cusomers (=cddeb) that have a total sales (= omzet-bedr) of >20000<30000 (and so further on)

When I do this:

count

({<[omzet-bedr]={'>20000<30000'}>}distinct(cddeb))

the fomula is okay. But this doesn't sum the sales.

When I add sum to the formula: 

count

({<sum([omzet-bedr])={'>20000<30000'}>}distinct(cddeb))

   it doesn't work any more.

Why?

What do I do wrong?

Can someone help me out.

[tresesco]

Try like:

Count(If(Aggr(Sum(omzet-bedr), cddeb)>20000 and Aggr(Sum(omzet-bedr), cddeb)<30000, cddeb))

[swuehl · Accepted solution]

Try like this

count({<cddeb = {"=sum([omzet-bedr]) >20000 and sum([omzet-bedr]) <30000"}>} distinct cddeb )

[#4]

Hi

count

({<[omzet-bedr]={'>20000<30000'}>}distinct(cddeb)) this is correct

({<sum([omzet-bedr])={'>20000<30000'}>}distinct(cddeb)) this is not correct

dont give sum with field name 

set analysis exp is like

sum({<[omzet-bedr]={'>20000<30000'}>}distinct(cddeb))  try like this

[israrkhan]

try this.

count(if({<cddeb = {"=sum([omzet-bedr]) >20000 <30000"}>}) distinct cddeb )

[anitamanders]

Thank you Swuel,

this works great!

[wajiha]

hi everyone,

Need a little help here. 

I'm trying to do on avg of float day in certain range, count number of retailers. here's the expression. but it doesn't work as expected.

count(if({<KYSC.FLOAT_DAY = {"=avg([KYSC.FLOAT_DAY])>=0<1"}>}) distinct KYSC_SALE_CHNL_CD )

please help.

thanks