Set analysis using a function

[maurorenazco]

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 ?

[NitinK7]

Hi,

try the below expression it will work

sum({<Year={'2019'},transfer_agency={'$(Len(trim(transfer_agency))=0)'}>}Obligation).

Regards,

Nitin.