How to use multiple conditions?

[#1]

Hi all,

I want to write a statement like below but it doesn't work.

count({<[visit state]={"yes"} , [order state]={0} or [state number]>=130511>} terminal )

In another word, I want to count terminals that visited and they have order to visit, or they have state number bigger than 130511.

I wonder if you could help me?

[tresesco]

May be like:

count({<[visit state]={"yes"} > * (< [order state]={0}>+< [state number]={'>=130511'}>)} terminal )

or

count({<[visit state]={"yes"} , [order state]={0}>+<[visit state]={"yes"} , [state number]={'>=130511'}>} terminal )

Edit: corrected a brace in the second solution.

[ahaahaaha]

Hi,

Maybe something like this?

count({<[visit state]={'yes'}, [order state]={'0'}, [state number]={">=130511"}>} terminal )

Regards,

Andrey

[#4]

Thank you in advance but unfortunately any of them didn't work.

[#5]

Dear Andrey,

Thank you for your comment. But it didn't work.

In addition I think I should use or function. But I have problem with the function.

[adamdavi3s]

count({<[visit state]={"yes"} , [order state]!={0},[state number]={">=130511"}>} terminal ) + count({<[visit state]={"yes"} , [order state]={0},[state number]={"<130511"}>} terminal )

[#7]

Hi,

I think Treseco B second solution is ok but there was mistake in parenthesis. The correct one is below:

count({$<[visit state]={"yes"} , [order state]={0}>+<[visit state]={"yes"} , [state number]={'>=130511'}>} terminal )

BR,

Milosz

[sasiparupudi1]

=count({<[visit state]={"yes"}>+<[order state]={0}>+<[state number]={'>=130511'}>

} terminal )

[HirisH_V7]

Hi

you can write like this,

If([order state]='0' and  [state number]>=130511, 


count({<[visit state]={"yes"}>} terminal ))


OR

If([order state]='0' or [state number]>=130511, 




count({<[visit state]={"yes"}>} terminal ))

HTH,

Hirish