3 Replies Latest reply: Jan 10, 2012 5:19 AM by Gordon Savage RSS

    Straight Table: sum(amount) when condition is fulfilled...



      I'm making a straight table with a sum of purchases shown for each month. This first column is for cloths, the next for household goods etc...


      making the sum is not difficult: Sum(amount) but when I add an 'if' so I only include items that are cloths (for example Goods='cloths') the result is always zero.


      Whats wrong with this statement as expression:




      What should be changed?