Why one condition work when add one more condition it return wrong value ?

[paulyeo11]

Hi All

My expression below work fine :-

sum(if([Sales Stage]='Sales_Fulfillment',(Amount)))

But when i want to add one more condition , it does not give the correct result :-

sum(if([Sales Stage]='Closed_Won' or 'Sales_Fulfillment',(Amount)))

if i use and , it does not display any value. ( below expression is wrong , so cannot use and )

sum(if([Sales Stage]='Closed_Won' and 'Sales_Fulfillment',(Amount)))

May i know where go wrong ?

Paul Yeo

[paulyeo11]

my QVW

[kenphamvn · Accepted solution]

Hi

Try this

sum({<[Sales Stage] ={'Closed_Won','Sales_Fulfillment'} >} Amount)

Regards

An Pham

[paulyeo11]

Hi An Pham

Thank you

So it is possible to use if instead of SET ?

Paul

[kenphamvn]

Hi

Yes

you can using If statement instead SET

sum(if([Sales Stage]='Closed_Won' or [Sales Stage] ='Sales_Fulfillment',(Amount)))

Regards

An Pham

[paulyeo11]

Hi Pham

Thank you very much , now i know where i make the mistake

Paul