set analysis - 2 condition in one field

[emilyrabbit]

HI , I use set analysis, and I need to restrict [Order Type Mini] 2 condition. But I found only [Order Type Mini]={"<200"} worked. 

[Order Type Mini]={">0"}  didn't work. what should I do?

Count(
{<[Order Type Mini]={">0"},[Order Type Mini]={"<200"},[Order Type Code]={'ZSTD','ZTTB'},[Fact_Type]={'FACT_ORDER'}>}
distinct [Order Document Number]
)

[Or · Accepted solution]

You can't use two separate sets on the same field as the latter will override the former (or possibly the other way around, I forget which). You would need to use e.g.

[Order Type Mini]={">0<200"}

[emilyrabbit]

I met another problem, it goes wrong. could you pls help check it ?

Count(

{$<[Order Type Mini]={">0<200"},[Order Purchase Order Number]<>{'*TQBH*'},[Order Type Code]={'ZSTD','ZTTB'},[Fact_Type]={'FACT_ORDER'}>}

distinct [Order Document Number]

)

[F_B]

Hi @emilyrabbit ,

excuse my intromission but what is this highlighted in red? 

[Order Purchase Order Number]<>{'*TQBH*'}

Maybe you need 

[Order Purchase Order Number]-={'*TQBH*'}

[emilyrabbit]

HI welcome,

thanks ,I tried . [Order Purchase Order Number]-={'*TQBH*'} failed.

but below works:[Order Purchase Order Number]=-{'*TQBH*'}

[Qrishna]

Try: Count({$<[Order Type Mini]={">0<200"}, [Order Purchase Order Number]-={"*TQBH*"}, [Order Type Code]={'ZSTD','ZTTB'}, [Fact_Type]={'FACT_ORDER'}>}distinct [Order Document Number])