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

    set analysis

    Christian Wylezol

      Hi,

       

      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.

      Chris