Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Sunny,
thanks, it runs 🙂
regards,
Fritz
Awesome