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.



      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.