Advanced Aggregation in List Box

[prathipsrinivas]

Hi Guys,

I am using Aggregation Expression like this 

=Count(Aggr(If(count(GuestSKey)>2,1) ,Date,GuestName)) 

to find how many times in a single day , the Count(GuestSKey) is more than 2 for Guest name.

The thing is, now if I want to show these resultant in a list box, it is throwing error or it shows nothing.

It would be really helpful if anyone could point out what I am missing or where i am going wrong.

Thanks in Advance!

Prathip

[prathipsrinivas · Accepted solution]

Sorry Guys, Very Silly me.

Just had to one more aggr for Guest Name , That will do.

Something like this

=aggr(Count(Aggr(If(count(GuestSKey)>2,1) ,Date,GuestName)),GuestName)