8 Replies Latest reply: Nov 12, 2012 12:41 AM by tusharmehtadxb RSS

    Sum of multiple field value

      Hi,

       

      how to sum multiple field value into single expression.

       

      =sum({$<DIVISION ={'L'}>} GROSSWT) OR sum({$<DIVISION ={'D'}>} PCS)

       

      In above mention example, If I am using first part I am able to see the sum of division "L" on my expression but when I am addting OR for second value my calculation give me -1 as value.

       

      Any idea why ? and if any other way to do that.