2 Replies Latest reply: Dec 5, 2017 11:13 AM by Ryan Metcalf RSS

    Number of Rows that have a Value

    Ryan Metcalf

      How do I get the number of rows that have a value in a dimension?

       

      I have tried:

      Sum(Aggr(Count(DISTINCT {<ExpectedCases = {'*'}>} OperatorName),OperatorName))

      noofrows(column(1))

      Sum(if(isnum($(vEC))=-1,1,0))

      max(rank(total column(1))

       

      What I'm trying to do is modify this formula

      (rank(total column(1))/(noofrows(TOTAL)/2))-1

      so that denominator is number of records in the dimension that have a value instead of the total records in the dimension.

       

      Please let me know if you have any questions.