5 Replies Latest reply: Jan 17, 2018 10:57 PM by Yeo Poh sai RSS

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

    Yeo Poh sai

      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