4 Replies Latest reply: Apr 22, 2016 3:38 PM by Sunny Talwar RSS

    Display '$' symbol to only highest sales amount on condition.

    susvithrocks susvithrocks

      Hello all,

       

      The possible output should be the following.

       

       

      Name

      Sort order

      Sales Amount

      Symbol

      Mike

      3

      13000

      $

      Jim

      3

      400

       

      Robert

      3

      200

       

      James

      4

      16000

       

      Robert

      4

      700

       

      Jack

      5

      14000

       

      Kevin

      5

      1000

       

       

       

       

       

      Description of the issue:

       

      The data contains only following fields.

      1.      Name

      2.      Sort Order

      3.      Sales Amount

       

      We want to add a dollar symbol “$” sign at the 13,000 as it is the highest amount in the lowest sort order #


      PFA for sample database.


      Any help would be appreciated.


      Thanks in Advance!


      The task can be shown in with straight table or table box.



      BR

      Susvith