Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jtrillori
Partner - Contributor
Partner - Contributor

Help with set analysis expression

morning,

how can i convert this expression

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

in a set analysis expression?

thanks and regards

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
er_mohit
Master II
Master II

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



jtrillori
Partner - Contributor
Partner - Contributor
Author

sorry the entire expression is like that

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

thanks

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
jtrillori
Partner - Contributor
Partner - Contributor
Author

works nice

thanks a lot