Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
try this
SUM(Distinct if(len( [Territory Name])> 0,if(len(KeepChar([Territory Name],'0123456789')) > 0,KeepChar([Territory Name],'0123456789'),1)))
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)))