wildmatch in expression

[capriconuser]

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?

[capriconuser]

yes but this is not working which you mentioned expression