3 Replies Latest reply: Mar 17, 2015 7:37 AM by Gysbert Wassenaar RSS

    How to ignore dimension for sum in expression

    Christophe MANNS


      Hello,

       

      I want make a sum in a expression but a join in my load script duplicate some data, for example

       

      id;mynumber;otherid,somedataofotherid

      1;25;87;somedata1

      1;25;88;somedata2

       

      How to sum mynumber and have 25 for result, I want to ignore otherid and  somedataofotherid ? I have also lot of filter and i use lot of if to filter my data

       

      Perhaps it's not possible ?

       

      Thanks in advance

       

      Christophe