Error: no value for the variable

[CloudYX]

Hi,

I am trying to count the number of distinct customer that have made order in the past 6 months using the following set analysis. It seem correct but it is not "recognizing" the variable (vMaxDate). Have separately testing the expression (AddMonths($(vMaxDate), -6)) and is returning correct value. Can anyone help?

Count(DISTINCT {<OrderDate-= {">=$(AddMonths($(vMaxDate), -6))"}>} CustomerID)

[mpc · Accepted solution]

Hi, 

Can you try: Count(DISTINCT {<CustomerID -= {">=$(=(AddMonths($(vMaxDate), -6)))"}>} CustomerID)
If CustomerID is a date instead. 

Best

[CloudYX]

Yes, It works now. Thank you. Yup, there is a typo in the text too as it should be OrderDate and not CustomerID.