7 Replies Latest reply: Jun 6, 2016 2:46 PM by Marcos Vinicius Coltro RSS

    Problem with total in dinamic table

    Marcos Vinicius Coltro

      Hi, I have an expression ($Bonus 1)  this way:

       

      =num((sum((((PRECOMAQ_PRECOBASE) - (PRECOMAQ_PRECOBASE * PRECOMAQ_DESCT_COMERCIAL)) * PRECOMAQ_BONUS1_PERCENT)))

      * Count({$<STATUS_NEGOCIACAO={'FATURADO'}>}CNC_ID)

      )

       

      The correct totals is 31.113,51 (sum values in collumn $ Bonus 1)

       

      Qlikview is multiplying the "correct total" (31.113,51) with sum Qtde Faturados (12)

       

      Who to correct this?

       

      imagem_qlikview.jpg