Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for
Did you mean:
Specialist II

## (P) / (E) in Set Analysis

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] )

Labels (1)
• ### Set Analysis Expression

1 Solution

Accepted Solutions
MVP

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])``
2 Replies
MVP

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])``
Specialist II
Author

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

Community Browser