Help with set analysis expression

[jtrillori]

morning,

how can i convert this expression

if(fecha < fecha1 and fecha>(fecha1-365), importe)

in a set analysis expression?

thanks and regards

[er_mohit]

SUM({<fecha={'>(fecha1-365)<fecha1'} >} importe)

[jtrillori]

sorry the entire expression is like that

sum(if(fecha < fecha1 and fecha>(fecha1-365), importe))

thanks

[Gysbert_Wassenaar · Accepted solution]

try sum({<fecha={"=fecha<fecha1 and fecha>(fecha1-365)"}>}importe)

[jtrillori]

works nice

thanks a lot