Get Values "Concat()" between

[MarcoARaymundo]

Hi!

I have a list result of the expression:

Concat(Aggr(Avg({<PRICE={'>0'}, PRICECV={'>0'}>} PRICE), COD, STORE), ';', PRICE)

=>12,25;12,25;12,25;12,98;12,98;12,99;12,99;12,99;13,17;13,98

I need take values between 12,35 and 13,41

Any ideas

Tks

[swuehl]

Maybe like

Concat(Aggr( If( Avg({<PRICE={'>0'}, PRICECV={'>0'}>} PRICE) >=12.35 AND Avg({<PRICE={'>0'}, PRICECV={'>0'}>} PRICE) <=13.41, Avg({<PRICE={'>0'}, PRICECV={'>0'}>} PRICE) ) , COD, STORE), ';', PRICE)

[MarcoARaymundo]

Tks, but did not work.

the values min and max, vary by product.