Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Avg where >= and <=

Hi,

i want to make an expression like this:

Avg({1<price={">=12"},price={"<=18"}>}sales)

i try this, too. But the avg number is not correct.

Avg({1<price={">=12" AND "<=18"}>}sales)

Avg({1<price={">=12","<=18"}>}sales)


Is one of these expressions correct?


regards,

sam

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Avg({1<price={">=12<=18"}>}sales)

View solution in original post

1 Reply
swuehl
MVP
MVP

Avg({1<price={">=12<=18"}>}sales)