12 Replies Latest reply: Aug 22, 2014 12:45 AM by Nikhil Garg RSS

    Query regarding Expression

    Nikhil Garg

      1 : According to me following Expression should return Sum of all the sales excluding the current selection with Company Name 'A'.

      2:  But it is return somewhere that it will return Company 'A' Sales excluding current selection.


      =Sum({1 - $<Company_Name = {'A'}>} Sales)

      Where Company_Name is a Field


      Is option 1 correct or 2 correct and if 2 is correct den why? Please clear my doubt.