18 Replies Latest reply: Sep 8, 2016 8:27 PM by Sunny Talwar RSS

    How to make rank() works in a text field

    Robson Candeo

      I have a table that shows informations for a client like this:

       

      Client     John Denver

      Rank               5

      Sales          $5,500

      Growth          35%

       

      But I need to put this infornation separetelly. So each one will be in a text field.

      The problem is that the second line where I have the Rank information, it does not worl as Rank is made to work only in tables.

      How can I show this rank information please?

       

      The expression is this:

      =rank(sum({1<[Reporting Calendar Year]={'$(vSelectedYear)'},[Reporting Calendar Quarter]={'$(vSelectedQuarter)'},[Client]={'$(vSelectedClient)'}>} $(vCurrency))) * avg(1)