Alternate state in formula doesn't work

[chriscools]

Hello,

I have a formula in which i want to incorporate alternate states.

if i use it like this it works:

but like this it doesn't work:

count ( {State2} {<OrderStatus={"On hold", "Placed" ,"Cancelled" , "Closed"}>} DISTINCT OrderNumber)

Any idea on how i need to fit it in to make it work?

thanx!!

Chris

[swuehl · Accepted solution]

Try like this

count ( {State2<OrderStatus={"On hold", "Placed" ,"Cancelled" , "Closed"}>} DISTINCT OrderNumber)

[vardhancse]

count ( {State2} DISTINCT OrderNumber)

[#4]

Hi Chirs,

You can use this code:

count ( {State2 < OrderStatus = {"On hold", "Placed" ,"Cancelled" , "Closed"} > } DISTINCT OrderNumber )

Ramya.

[chriscools]

Thank you, this works fine!!!

grtz,

chris