Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to sum(values) when x is between (-100, 20) in expression:
sum({<x ={'>-100'}, x={'<=20'}>} values)
can someone help me get correct expression? x ={'>-100'} part doesn't work. Thanks.
Hi Ying, simple quotes is usually used to look for literals, double quotes for searchs; also, if you use the same field two times only the last is kept, try with:
Sum({<x={">-100<=20"}>} values)
Hi Ying, simple quotes is usually used to look for literals, double quotes for searchs; also, if you use the same field two times only the last is kept, try with:
Sum({<x={">-100<=20"}>} values)
Thank you Ruben, it is exactly what I need
Ruben are there any situations where double quotes is not recommended.
Hi Dilip, I'm not sure of recommendations, but I use single quotes for literals, when there is an exact text to filter like:
Option={'Y'}
And Iuse doube quotes if there are is comparison simbol (=,<,>) or a star character like:
Option={"Y*"}