3 Replies Latest reply: Jun 25, 2018 12:35 PM by Thiago Justen Teixeira RSS

    How to calculate with NULL values included

    Pascal Schwegler

      Hi Community,

       

      I would like to make calculations on a table.

       

      Sourcedata:

      Table 1.PNG

       

      I tried to make a calculated field in my load script:

      (Column2+Column3) as 'CalculatedColumn'

       

      But the output of "CalculatedColumn" is empty in my charts where Column 1 is 2.

      I expected 150.000 + 0 is 150.000 and 300.000+0=300.000.

       

      Could anyone tell me why this column is empty?

       

      Thanks in advance.