Having clause in an expression

[Anonymous]

Hi guys,

I am trying to find distinct customers who have a value of spend more than zero within a range.

My fields are called CustNo and val and the state is called Range 1 (or Range 2).

Is this possible in an expression?

Thanks for your help as always

[Anonymous]

Thanks again Anbu that has worked.  Really appreciate all your help here

I can't believe i was just missing a comma!