2 Replies Latest reply on Aug 18, 2016 9:58 AM by Rajeev Pandey

    Sum Null Values on Dimension

    wil.ruiz.0

      Hello,

       

      I want to create a calculated field which sums all Null values in my customer dimension. Or, I can settle for the sum of anything that is NOT null. I need it as a measure because I want to subtract it from another measure afterwards.

       

      If null (Customer Dimension) then (Gross Sales Measure) else 0

       

      Any ideas on how to write this?

       

      Thank you!