aggr funcation

[#1]

we want count of sales unit code whose sum(Amount)>=1000000

count

(distinct aggr( if(sum(AMOUNT)>=1000000

),SalesUnitCode))

it's show zero

please help urgent basic

[#2]

use numcount

[#3]

where we use numcount

[#4]

please tell me the result what it should come for ur expression

[#5]

expersion worng

[#6]

Try this

calculate the sum of Amount at the backend i.e script

load sum(Amount) as xyz

resident TableName

group by code;

then count(if(xyz>1000,code))

[#7]

Hi

Test with

=sum( aggr( if(sum(AMOUNT)>=1000000 , 1 , 0) , SalesUnitCode))

regards

jj