8 Replies Latest reply on Aug 27, 2016 5:48 PM by panjala Srinath

    Sum of quantity for all values which are not null

    Prasenjeet Acharjee


      I have a problem. I am trying to find the sum of all rows which are not null for each product no.

      so for each product no. i want to list sum of all values where "Deal SO.Deal" field is not null. So, I will have two values - 1. sum of quantity for NULL value for each "Deal SO.Deal" and sum of the rest. Can i can some pointers on how to do this? Thanks in advance.