Expression

[smilingjohn]

HI All,

Can someone explain me what this below expression is doing ?

=concat(

  {$<

  Lead = ,

  Hierarchy = P(Hierarchy_S)

  >

  } distinct

  if (Aggr(

  Count(DISTINCT

  {$<

  Date={">=$(StartDate)<=$(EndDate)"},

  Lead = ,

  Hierarchy = P(Hierarchy_S)

  >} Lead_UID)

  ,Lead) >0,

  Lead &'|'&

  Num(

  Aggr(

  Count(DISTINCT

  {$<

  Lead = ,

  Hierarchy = P(Hierarchy_S),

  Date={">=$(StartDate)<=$(EndDate)"}

  >} Lead_UID)

  , Lead)

  , '#,##0')

  &'|'&

  if(wildmatch(GetFieldSelections(Lead),'*'&Lead&'*')>0, 1, 0)

  )

, ';')