4 Replies Latest reply: Dec 18, 2017 8:17 AM by Sunny Talwar RSS

    if statement to reduce dimensions

    Josh Pinfold

      I have an expression which calculates a % of coverage. I would like to limit the dimensions to where the coverage is 10% or more. The dimension is 'Insight' and the following is the expression for coverage (which i know works)

       

      =count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic))/(sum(if(not(isnull(Category)),TopicFlag))+count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic)))

       

      adding the expression into the if statement doesnt seem to be working

       

      if(count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic))/(sum(if(not(isnull(Category)),TopicFlag))+count(if(isnull(Category) and ExcludeWord<>'Yes' and not(isnull(Topic)),Topic)))>0.1, Insight)