2 Replies Latest reply: Apr 25, 2016 8:45 PM by David Kwiatkowski RSS

    Exclude blank/null from straight table

    David Kwiatkowski

      I have a data set with a column for Name_of_Covered_Drug and a column for the Total_Spend associated to that drug. There is some spend reported that is not associated to a drug so the Name_of_Covered_Drug can be blank. I want a table showing top 10 drugs by spend  but my table keeps including a single bar grouping all the blank drug names. I tried "Suppress when value is null" in Dimensions and I also tried the expression of

       

      Sum ({$<Name_of_Covered_Drug-={NULL}>}Total_Spend)

      also Sum ({$<Name_of_Covered_Drug={"*"}>} Total_Spend)

       

      Any advice on how to type expression so that it will give me Total Spend only when a drug name is present(excluding nulls)?

      Thanks