4 Replies Latest reply: Aug 22, 2013 2:01 PM by chand S RSS

    Creating a column in the script

      Hi friends:

      Can you please help me with this

      I have a column in the table called Category. It has 2 values - Cat1,Cat2

      In a list box for Category i get 2 values like

      Category

      Cat1

      Cat2

       

      When user selects Cat1, i perform a calcualtion on this like

      If Category = 'Cat1', revenue*100

       

      When user selects Cat2, i perform a calcualtion on this like

      If Category = 'Cat2', revenue*200

       

      i don't have a 3rd category in the table , but users want to list 3rd category in the list box , which should be in the list box of Category

      and should look like

      Category

      Cat1

      Cat2

      Cat3

      When user selects Cat3, i should perform a calculation on this like

      If Category = 'Cat3', (revenue*100) + (revevnue*200)

      I can create Cat3 as a separate list box, but they want Cat3 should be under the same list box so that they can select only one among Cat1,Cat2 and Cat3.