Data360 Analyze

 View Only

  • 1.  How to Sum 3 column value but can contain NULL

    Posted 01-21-2024 18:54

    Hi Support

    I was hoping that someone could help me sum rows from 3 columns, but some values can contain NULL



    ------------------------------
    andrew darnell
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: How to Sum 3 column value but can contain NULL

    Posted 01-22-2024 01:45

    Can't you replace the nulls' with zeroes? so it becomes a valid object to perform int operations on?

    And if you want to perform string operations i would replace the null's with an empty string.



    ------------------------------
    Henrik B
    E.ON Sverige
    ------------------------------



  • 3.  RE: How to Sum 3 column value but can contain NULL

    Posted 01-22-2024 01:51

    Hi Henrik

    Thanks for that, it works with me changing to double format



    ------------------------------
    andrew darnell
    Knowledge Community Shared Account
    ------------------------------

    Original Message


  • 4.  RE: How to Sum 3 column value but can contain NULL

    Employee
    Posted 01-23-2024 07:11

    You may also want to investigate the use of the Calculate Fields node for these types of calculations - it provides default values for different data types which simplify the processing of data containing NULL values:



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------