7 Replies Latest reply: Jun 7, 2016 6:17 AM by kushal chawda RSS

    set analysis



      I am trying to optimize a calculation because it is not always calculating correctly.

      I Need to Change it into a set Analysis calculation but I dont get it to work.


      sum((if (xrefNr like '6*' and linetype=158 and linetype='158' and xref_GRPCODE='2KRE' and not (doccode like 'Z*' or doccode like 'BANK*' or  doccode like 'A*'),Buchungsbetrag,0)))

      Does somebody have an idea how the set Analysis must look like?


      Very much thanks in advance.