Distinct in Expression

[#1]

I am using the following Expression :

SUM(if(len( [Territory Name])> 0,if(len(KeepChar([Territory Name],'0123456789')) > 0,KeepChar([Territory Name],'0123456789'),1)))

How do I add Distinct [Territory Name] in this expression ?

Thanks

VENU

[#2]

hi

try this

SUM(Distinct if(len( [Territory Name])> 0,if(len(KeepChar([Territory Name],'0123456789')) > 0,KeepChar([Territory Name],'0123456789'),1)))

[#3]

hi

try this

SUM(if(len(Sum(distinct [Territory Name]))> 0,if(len(KeepChar(Sum(distinct [Territory Name]),'0123456789')) > 0,KeepChar(Sum(distinct [Territory Name]),'0123456789'),1)))