Question

Invalid expression: Expression incomplete error

  • 12 October 2021
  • 0 replies
  • 5 views

  • New Member
  • 0 replies

I'm trying to write a simple case statement in custom dimension but I'm getting 

Invalid expression: Expression incomplete error Can some one please help me.

 

case when ${d_cus_lu.ltd_sls_amt}<5000 then "Less than 5000"
when ${d_cus_lu.ltd_sls_amt}>=5000 AND <10000 then "Between 5000 and 1000"
else "Greater than 10000"
end 


0 replies

Be the first to reply!

Reply