Difference in Location of Set Analysis

[dclark0699]

I'm trying to limit the rows in my table using set analysis

This works as expected: (where the variable is just determining which departments to include)

=COUNT(DISTINCT

                 $(vDeptSetAnalysis)

                      [Order ID])

This version gives me 10x more results:

	=COUNT(DISTINCT
		{
		<
				[Order ID]=P($(vDeptSetAnalysis) [Order ID])
			>
		}
	[Order ID])

Can anyone articulate the difference between the two? In my head they are saying the same thing

[phaneendra_kunc]

It all depends on what you have in that vDeptSetAnakysis variable.

first one is just straight forward count distinct. But second one is basically you are getting all possible OrderID's based on your set analysis.