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)
)
, ';')
