limitar expresión por intervalos

[#1]

Hello Community

I have the following expression. sum({$<CeCo={'AS1*'}>}ImporteAdm) and brings all the values ​​that start with AS1.

only need to bring the AS100100 AS100000 CeCo and AS109999 AS100106 at two intervals (not to take the AS100105)

anyone can help me

regards

[#2]

Hola.. no sé si es la mejor solución... pero funciona

(Hello, I don't know if this is the best solution.. but just work)

sum(if((CeCo>='AS100000' and CeCo<='AS100100') or (CeCo>='AS100106' and CeCo<='AS109999'),ImporteAdm))

Saludos!

[adelmeire]

hi! if your goal is to take all AS1 values except AS100105, you could try this:

sum({$<CeCo={'AS1*'}, CeCo-={'AS100105'}>} ImporteAdm)

hope that help you.