Set analysis statement for If statement

[markgraham123]

Hi All,

Regarding performance, Set analysis or If statement???

Which would work quicker.

Could someone help me in scripting the below statement using Set analysis

=count(DISTINCT(If(Name='John',Awards)))

[marcus_malinow · Accepted solution]

Set analysis is definitely quicker!

count({$<Name={'John'}>} DISTINCT Awards)

[markgraham123]

Thanq Marcus