Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have this expression
count(if(wildmatch(sm_no,'US*'),left(sm_no,9),amount_lc))
in that condition i am trying to get the sm_no who start with US and extract first 9 digits
further more i want to add another condition that code =947 so how i add into this
is this expression is correct?
i want both ,, so how i apply that left condition in set analysis?