Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
please explain below expression.
Count(
{<$>
+ 1<[Display Score]={$(=If(
len(GetFieldSelections(Score))>1,
(chr(39) & Concat(DISTINCT Score, chr(39) & ',' & Chr(39) ) & chr(39))
,Score))}>
+ 1<[Overall Lead Score]={$(=If(
len(GetFieldSelections(LeadScore))>1,
(chr(39) & Concat(DISTINCT LeadScore, chr(39) & ',' & Chr(39) ) & chr(39))
,LeadScore))}>
}
[Company Name] )
Thanks
sekhar.
Hi Sekhar,
This is what the expression doing.
It is calculating the count of Comany names with below condidtions
if there are any field selections on Score field, it is concatenating the distinct score values single quotes and comma
else it is taking score
if there are any field selections on LeadScorefield, it is concatenating the distinct LeadScorevalues single quotes and comma
else it is taking LeadScore
Let me know if it answers your question.
Thanks,
hemanth.
Hi Sekhar,
This is what the expression doing.
It is calculating the count of Comany names with below condidtions
if there are any field selections on Score field, it is concatenating the distinct score values single quotes and comma
else it is taking score
if there are any field selections on LeadScorefield, it is concatenating the distinct LeadScorevalues single quotes and comma
else it is taking LeadScore
Let me know if it answers your question.
Thanks,
hemanth.