Modifier and Aggregation question

[Anonymous]

Hi,

i want to count all sales, where the average price is <=3. What syntax must i use?

This syntax is not correct:

Count(DISTINCT{<Avg(price)= {"<=3"}>} sales)

regards,

Fritz

[sunny_talwar · Accepted solution]

What is the field you are checking the Avg(Price) on?

Try this:

Count(DISTINCT {<IDField = {"=Avg(Price) <= 3"}>} sales)

Replace IDField with the field you are Avg(Price) on

[Anonymous]

Hi Sunny,

thanks, it runs 🙂

regards,

Fritz

[sunny_talwar]

Awesome