Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
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)
1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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
Specialist II
Specialist II
Author

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