How can I count the number of time where Volume < 20 for a store ?

[suzel404]

Hi all,

I have a store with volume and I want to know, how many times the Volume is over 20 for this store.

You can see my attachement.

Thanks for your help.

[maxgro]

=Sum(if(aggr(Sum(Volume),Store_id,Date)<20,1,0))

[GabrielAraya · Accepted solution]

=Sum(

Aggr( if(Sum(Volume)>20,1,0)

        ,Date))

[suzel404]

Thanks for your response Massimo.

Your expression give me 20 and not 7 like I can see in straight table to the right side.

[suzel404]

Thanks you Gabriel !!

[maxgro]

you're right, I made under (<), not over