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

    Sum Null Values on Dimension




      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!