10 Replies Latest reply: Aug 1, 2016 2:35 AM by Kaushik Solanki RSS

    I want the Expression for following

    sumit jadhav

      I have Two fields in my data ,ie Ticket Type and Ticket Count, i want to write an expression as,

      if my ticket count is equal to 10 for ticket type 'p' then the count of ticket must be 1 and if it is greater than 10 ,20,30...........so on,

      suppose it is 11-20, then the count of ticket must be 2 and if it is 21-30, then the count of ticket must be 3.please help me to achieve this output.

      the following is the reffernce data.

       

       

      [Ticket Type], [Ticket count]

      S1                       5

      S2                       11

      E1                       15

      E2                        6

      E3                       7

      P                        11

      S2

      p                        10

      P                        22

       

       

       

       

      result must be,

      [Ticket Type], [Ticket count] 

      S1                       5

      S2                       11

      E1                       15

      E2                        6

      E3                       7

      P                        2

      S2

      p                        1

      P                        3

       

       

      please Note:

      10 tickets of type 'p'=1 ticket.

      remaining type of ticket count it as it is

      I wantexpression only for ticket type 'p'.