4 Replies Latest reply: Jan 24, 2015 12:27 PM by Prem Kumar Thangallapally RSS

    total sum is not correct

    Christian Wylezol


      Hi everybody,

       

      I have a problem with a sum in Qlikview.

      The column DefTax STBADJ is calculated with a percentage. The percentage is dependant on the KontoID.

      The Detailed lines are correct, but not the TotalLines [called "Gesamt"].

       

      DefTax STBADJ:

       

      =

       

      if(KontoID='60740', -Körperschaftsteuersatz*[Akt. Jahr STBADJ], if(KontoID='60746',-Gewerbesteuersatz*[Akt. Jahr STBADJ],
      -Unternehmenssteuersatz*
      [Akt. Jahr STBADJ]))

       

      hc_133.jpg

      I think the Total-Line is calculating with the percentage from the Total-Line.

      But this should not be done.

       

      Does anybody knows a solution?

      Very much thanks in advance.