Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] )
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])
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])
Thanks Sunny. That worked perfectly. Have a great weekend.