3 Replies Latest reply: May 6, 2014 8:47 AM by Yurii Ratushnyi RSS

    Calculations not in all rows

    Yurii Ratushnyi

      Hello guys,

       

      When I try to make arithmetic operations with values in rows result is calculated only in rows where exist every part of expression. Here is example

       

      sample:

      load * inline [

      ID, T1, T2

      1, 1, 1

      2, , 1

      3, 1, 1

      4, 1,

      ]

      ;

      Left Join (sample)

      LOAD

        ID,

        T1+T2 as SUM

      Resident sample

      ;

       

      Result is

      2014-05-06 16.31.22.png

       

      How can calculate sum for every row? So, for ID 2 and 4 it should be 1