1 Reply Latest reply on Mar 6, 2013 9:01 AM by Tracy Rodgers

    how to turn rank value as calculated to a string (dimensional value)

    Ji ZHANG

      James Bakers wonder guide on how to calculate the rank according to a given variable using "calculated field" scripting:



      The script to calculate standard rank is:

      IF ISNULL(SUM([Measure])) THEN



        IIF(SUM([Measure]) == LOOKUP(SUM([Measure]), -1),

            PREVIOUS_VALUE(1), INDEX(), 1)



      I want to ask how to turn this rank value as calculated to a String or a dimensional value.


      I sense a slight modification of the above script will do the magic....


      Thanks in advance!