Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I run into the following expression
sum({<${year=2019}, transfer_agency={=“len(trim(transfer_agency))=0”}>Obligation
my question is related to section
transfer_agency={=“len(trim(transfer_agency))=0”}
I cannot tell what the expression is evaluating or assigning . At first I thought it Was $ expansion to evaluate a comparison value, but it is not the right syntax transfer_agency={=$(“len(trim(transfer_agency)))=0”}.
this part of the expression len(trim(transfer_agency)), get rid of the leading spaces , and return the length of the string.
but when I read the expression like this
transfer_agency={=“len(trim(transfer_agency))=0”}
first, I think that it should be single quotes and not double quotes to evaluate the expression. The to me it seems the expression does the following :
let say agency_transfer = ‘ N A SA’
transfer_agency=[ (4)=0]
could any one please help me understand the expression, please ?
Hi,
try the below expression it will work
sum({<Year={'2019'},transfer_agency={'$(Len(trim(transfer_agency))=0)'}>}Obligation).