20 Replies Latest reply: Dec 27, 2017 6:35 PM by Sunny Talwar 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))



      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.