Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying find the count of customers who shipped 2 months prior to their due date and here is the expression am using but it just shows blank.please let me know if I am doing something wrong in the expression.
=count({<Date(Shipping_Date,'YYYYMM') = {">=$(=Date(AddMonths(Customer_Due_Date1,-2),'YYYYMM') <=$(=Date(Customer_Due_Date1,'YYYYMM'))"}>}
distinct Customer_Key)
Thanks,
Swetha
I do not think you can use an expression in the first section of set analysis.
Try doing
Date(Shipping_Date,'YYYYMM')
in the script as a new field, then using the new field there instead
Thank You for the reply.
I did replace the first part of the expression with a filed but still does not give the reult.I thibnk something is wrong with
{">=$(=Date(AddMonths(Customer_Due_Date1,-2),'YYYYMM') <=$(=Date(Customer_Due_Date1,'YYYYMM'))"}>}
because when I replace the above value with some year and number the expression gives the result.
Thanks,
Swetha
Thank You for the reply.
I did replace the first part of the expression with a filed but still does not give the reult.I thibnk something is wrong with
{">=$(=Date(AddMonths(Customer_Due_Date1,-2),'YYYYMM') <=$(=Date(Customer_Due_Date1,'YYYYMM'))"}>}
because when I replace the above value with some year and number the expression gives the result.
Thanks,
Swetha