3 Replies Latest reply: Nov 1, 2012 4:09 PM by Vegar Lie Arntsen RSS

    how to use sum multiple field value



      I have requirement where I want to fetch more then one field value in to single expression.


      In below mention example there is more then one division and for each division value stored on there respacted field.


      I have tired single statement and found result is correct.


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


      But when I am using OR I am getting -1 as value.


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


      So now I am not sure my method of using OR is correct ?