Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Null Summation in 'Group by' Step

  1. #1

    Default Null Summation in 'Group by' Step

    HI,
    I tried summing up a column with null values in a 'group by' step. A Null result was expected but the result was zero. Can you please help.

  2. #2
    Join Date
    Mar 2011
    Posts
    257

    Default

    Your post is a bit cryptic...
    what database are you using ?
    what was your query ?
    It is wierd that you have 0 when you expect null usually it's the other way around !

    grtz,
    Hans

  3. #3

    Default

    I am using a DB2 database.

    Group by step sums up NULLs to zero but not NULL.

    I have columns A, B and C. I grouped up A and B and performed a summation on C. For a certain group of A and B, all the C values are null in the source. While a summation is performed, it should return a NULL. But what i get is a zero.

    I found a work around but it makes the transformation bulky. Please help.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.