4 Replies Latest reply on Jan 23, 2014 1:34 PM by Jose Florez

    how in a calculation can be assigned a specific field of a string

    Jose Florez

      I'm doing an analysis where I get the 3 best sellers of the month, with the percentage of sale, in a calculation I want you to insert the name of the vendor according to their position.

       

      the syntax of the formula I'm doing generates the following error:

       

      case [ranking top3 agencia]

      when 1 then [agencia]

      when 2 then [agencia]

      when 3 then [agencia]

      end

       

      [agencia] = are the names of the vendors, like giving the exact position

       

      example:

      1 george 90%

      2 daniel 80%

      3 michel 75%

       

      thanks