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




      if(Dim = 'C',