5 Replies Latest reply: Aug 13, 2016 2:25 AM by Kaushik Solanki RSS

    expression

    Shantnu Patel

      I have data as mention below.

       

      TypeSub TypeValues
      YA100
      YB200
      YC300
      NA400
      NB800
      NP900
      NR100
      YA200
      YB300
      YC2000
      YD3000
      NE100
      NF200
      NB5000
      NC2000

      requirement is like i have to calculate sum of Values.

      when user select Type Y from list box and respective values from Sub Type list box it should show maximum value of values as sum.

      Like if user select Y from Type list box then select A,C,D from another Sub Type list box sum of values should display 3000 that is maximum value.

      in another case if user select N from Type list box and A,B,P from Sub Type list box sum of values should be 2100 that is sum of A,B,P.

      Please let me know how to get this sum expression to show above requirement.