0 Replies Latest reply: Sep 8, 2016 6:30 AM by Vigneshraj T RSS

    Set expressions

    Vigneshraj T
      Table A
      S.nocodeDoc.codeTotal
      1ILE100120
      2ILE100240
      3ILE100330
      4ILE100450
      5ILE100580
      Table B
      s.nocodeRef codeRef Doc codeTotal
      1SRLEILE100220
      2SRLEILE100440
      3SRLEILE100580

       

       

      hI above are my two tables .

       

      table A is invoice  and table B is sales return.

      i need to find the sum of sales by subtracting the second table . as if sales return has been done it wont be consider as profit.

       

      how can i achieve this in expression. please help

      Thanks

      Vignesh