Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Double Qoutes inside another Double Qoutes in expression

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

1 Reply
sunny_talwar

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