exp

[smilingjohn]

HI All ,

can someone explain this what is thi expression doing ? i have field (listbox) by nam iball within which there is only on string that is "perform"

basicall i need to show he number count for " perform" too like other brands  hence i copied this expression from where i copied this it has  3 data in that ( there is a listbox called Department and whitin department there are finance, HR, Acnt) but for iball there is only one that is perform . thereofre i need to edit this expression accordingly

=concat(

  {$<

  Iball = ,

  Hierarchy = P(Hierarchy_S)

  >

  } distinct

  if (Aggr(

  Count(DISTINCT

  {$<

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

  Iball = ,

  Hierarchy = P(Hierarchy_S)

  >} Lead_UID)

  ,Iball) >0,

  Iball &'|'&

  Num(

  Aggr(

  Count(DISTINCT

  {$<

  Iball = ,

  Hierarchy = P(Hierarchy_S),

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

  >} Lead_UID)

  , Iball)

  , '#,##0')

  &'|'&

  if(

  Aggr(

  Num(

  Count(DISTINCT

  {$<

  Iball = ,

  Hierarchy = P(Hierarchy_S)

  >} Lead_UID)

  , '#,##0')

  , Iball) > 0, 1,0)

  &'|'&

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

  )

, ';')