How to improve this SA formula

[vmcastejon]

Hi, how can I improve this formula into Set Analysis

Count(DISTINCT if(Date1 = Date2, Name))

Thanks!

[cristianj23a]

Add the condition in script:

if ( Date1 = Date2 , Name) as Name

Then in the Set analysis  Count (DISTINCT Name)

regards.

[marcus_sommer]

It depends on your datamodel if you could use SA. You could try it with:

count({< Name = ["=Date1=Date2"}>} Name)

and if not should at least the following approach perform significantly better:

if(Date1=Date2, count(Name))

- Marcus