15 Replies Latest reply: Sep 8, 2016 2:11 PM by Stefan Wühl RSS

    Sum Where Field Is Null in Data Model

    Dave Melillo

      Below is my data model:

       

      DM1.PNG

       

      If have created a straight table with the following fields:

       

      DM2.PNG

       

      I want to do some basic DQ calculations. Such as SUM AMOUNT USD when Contact ID is NOT NULL and Lead ID IS NULL.

       

      Not having much luck after some research.

       

      Any help is appreciated.