Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
below expression is giving error because I am using Double Qoutes inside another Double Qoutes in expression.
Please let me know if there is a another way to write the same syntax.
concat(distinct
{
<dim1={"=count({<dim2={">10"},order_date={'$(=max(order_date))'}>}dim1)>=1"}
-
{"=count({<dim2={">10"},order_date={'$(=min(order_date))'}>}dim1)>=1"}>
}
dim1,Chr(10))
Try this:
Concat(distinct
{
<dim1={"=count({<dim2={'>10'},order_date={'$(=max(order_date))'}>}dim1)>=1"}
-
{"=count({<dim2={'>10'},order_date={'$(=min(order_date))'}>}dim1)>=1"}>
}
dim1,Chr(10))