6 Replies Latest reply: Jul 10, 2018 2:42 PM by Mikael Scorielle RSS

    Customized message in text box

    Kaustabh Mitra

      Hi All,

       

      I am trying to create a customized message in a text box based on the highest sales value.

       

      I have the data as follows:

      State          Sales 2018

      A                    300

      B                    400

      C                    350

      D                    150

      E                    600

      F                    250

       

       

      Based on the maximum sales of a particular state I would like the text box to display the following message:

       

      "Well done (State name)" on achieving (sales value) sales in 2018."

       

      The state name with the maximum sales (in this case State E) should be shown in the message along with its value (i.e. 600).

       

      Please help..