6 Replies Latest reply: Nov 5, 2014 7:49 AM by Puttemans Johan RSS

    How to exluding one value in apply Map

      Hi Friends,

       

      I am using apply map function to recognise the sales type.

       

      I have use three columns x ,y, z to identify which sales type it is.

       

      So  X Y Z

            1 2 1

             2 1 3

             4 5 7

       

      The problem is the combinations of X and Y are less. But the Z can take any value excluding ZERO (0).

       

      So How to exclude 0 from my z value. Should I write all the values for z also. there are hundred in Numbers.

       

      Thanks

      Pavan