(P) / (E) in Set Analysis

[tmumaw]

Trying to use the (P) and having problems.  Any idea what might be wrong with this?  What I am trying to achieve is to count the number of customers in all years.

Thanks

Count(DISTINCT{$<StartYear_Ind = {1},[Sold To] = P({1<[Valid To Year]={$(=$(vCYear) - 2)}>})*P({1<[Valid To Year]={$(=$(vCYear) - 1)}>})>} [Sold To] )*P({1<[Valid To Year]={$(=$(vCYear) - 0)}>})>} [Sold To] )

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<StartYear_Ind = {1}, [Sold To] = P({1<[Valid To Year] = {$(=$(vCYear) - 2)}>}) * P({1<[Valid To Year] = {$(=$(vCYear) - 1)}>}) * P({1<[Valid To Year] = {$(=$(vCYear) - 0)}>})>} [Sold To])

[tmumaw]

Thanks Sunny.  That worked perfectly.  Have a great weekend.