Conditions in Expression

[bashar_f]

Hi,

I have the following expression : -

sum({$<status={'Closed'}>} Duration/60)

which is basically : Sum(Duration/60) Where Status = "Closed"

What I want is

Sum(Duration/60) where status = "Closed" AND Product_Type=" Software" or "Hardware" or "Training"

How do I do this?

[SergeyMak]

Hi,

Try this expression

sum({$<status={'Closed'}, Product_Type={"Software","Hardware","Training">} Duration/60)

Sergey

[sushil353 · Accepted solution]

Try Below:

Sum({<status={'Closed'},Product_Type={'Software','Hardware','Training'}>}Duration)/60

HTH
Sushil

[ashfaq_haseeb]

Hi,

Try this

Sum({<status={'Closed'},Product_Type={'Software','Hardware','Training'}>}Duration)/60)

Regards

ASHFAQ