Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try this
sum({<[Sales Stage] ={'Closed_Won','Sales_Fulfillment'} >} Amount)
Regards
An Pham
my QVW
Hi
Try this
sum({<[Sales Stage] ={'Closed_Won','Sales_Fulfillment'} >} Amount)
Regards
An Pham
Hi An Pham
Thank you
So it is possible to use if instead of SET ?
Paul
Hi
Yes
you can using If statement instead SET
sum(if([Sales Stage]='Closed_Won' or [Sales Stage] ='Sales_Fulfillment',(Amount)))
Regards
An Pham
Hi Pham
Thank you very much , now i know where i make the mistake
Paul