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

    Sum of multiple field value



      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.