Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
)
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"}
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"}
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]
)
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*'}
HI welcome,
thanks ,I tried . [Order Purchase Order Number]-={'*TQBH*'} failed.
but below works:[Order Purchase Order Number]=-{'*TQBH*'}
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])