15 Replies Latest reply: Jul 18, 2017 5:19 AM by Ravi Balar RSS

    HardCode Value

    Priya R

      Hi Community,

       

      I have table like below. And requirement is if Dim=C then I need sum(Val1) and I have writtern expression like below but problem is if I select any Dim value then it is disappearing but as per my requirement it shouldn't be disappear. so If I select A then C value is 100 and for B 200 and for C 300.

       

       

      LOAD * INLINE [
      Dim, Val, Val1
      A, 10, 100
      B, 20, 200
      C
      ]
      ;

       

       

       

      if(Dim = 'C',
      $(=sum(Val1)),
      sum(Val)
      )

       

      -Priya