how to write set expression for the given situation

[#1]

I want to get count of id whose sum(dollar)<15.  how to write set expression for it???

for example : sum(dollar)< 15 is:

id= 4 , sum(dollar)=7

id=3, sum(dollar)=14

so these are less than 15 . so output should be 2.

[vishsaggi]

Try this?

Your Dim as ID

and Expr as = Sum({<ID = {"=Sum(dollar) < 15"} >}dollar)

[surendraj]

This will fit your requirement...

AGGR(Sum({<ID = {"=Sum(DOLLAR) < 15"} >}DOLLAR),ID)

Thanks,

Surendra.

[maxgro · Accepted solution]

In a text box

=count(

{$ < id={"=sum(dollar)<15"} >}

distinct id)

[#5]

thanks a lot , very helpful