Count Distinct or aggr

[#1]

Hi all,

I have an easy question (but after many test actually i'm confused...)

I would like to know on each dimension (Market Area)

- how many order i have count(distinct OrderId) It works

-----------------------------------------------------------------------------------------------------------------------------------------------------

how many order have a price >100€ Wrong Result

=sum(aggr(if(Price >100, 1,0 ) , OrderId) ) or

if(Price>100, count (distinct OrderId))

_____________________________________________________________

how many lines have a price > 100€.

sum(if(O$PREZ>10), 1,0)

Wrong ! Wrong !

Wrong !

Many Many Thanks

Claudio

[spsrk_84]

Hi,

Try in this way

Count( if(Price>100, distinct OrderId))

[#3]

hi,

probably u can use this

Count(distinct If(aggr(Sum(Price),OrderId)>100,OrderId))

i haven't tested it but u can give it a try

thanks

[#4]

hi

try this

count(distinct(if(Price>100,orderid)))

regards

Peter

[#5]

Many thank

they work perfectly (The first one was wrong)

Claudio