MAKE EXPRESSION IN RANGE

[Xolink1389]

hello i wanna know if its possible make this expression in range

sum({<Cuenta={1101100101,1101100102,1101100103,1101100104,1101100105},
ID_Clase,MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)

for example make sum({<mid(Cuenta,1,4)={1101}, its possible?

i try this also too, but nothing

sum({<Cuenta={"$(=Mid(Cuenta,1,4))<=1101"},
ID_Clase,MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)

[vincent_ardiet_]

Try maybe with an equal:
sum({<Cuenta={"=$(=Mid(Cuenta,1,4))<=1101"},
ID_Clase,MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)

[Xolink1389]

on syntaxis maybe right but still not wotk

 
i fixed the expression adding an Min but still not work

maybe got something with the fact that "Cuenta" contains 10 digits? im trying to make the range more short, to not put something like this  sum({<Cuenta={">=1101000000 <=1103999999"} this case totally works but i dont wanna use it like that

[vincent_ardiet_ · Accepted solution]

 My bad, I focused on the equal but I forgot the rest of the expression.
Try with:

sum({<Cuenta={"=Mid(Cuenta,1,4)<=1101"},
ID_Clase,MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)

Else $(Mid...) will be evaluated globally and not line by line which doesn't work.

[Xolink1389]

Thanks a lot work magicly 😄 perfect for what a i was looking for 😀