3 Replies Latest reply: Dec 10, 2012 12:14 PM by Mayil Vahanan Ramasamy RSS

    if statement using expressions

      Hi all,

       

      My problem is that I can't make my  IF statement to work.

      Model of my problem:

      My data:

      House typePrice1Price2
      A1000
      A3000
      B7000
      B8000

       

       

      Want to get pivot table:

      House typePrice
      A4000
      B15000

       

      Price is expression:  if([House type]=('A'), $(eSumPrice1), $(eSumPrice2))

       

      My expressions:

      eSumPrice1=Sum(Price1)

      eSumPrice2=Sum(Price2)

       

      It must be so simple, pls help me ASAP!

       

      Tiv0li