1 Reply Latest reply: Feb 7, 2016 1:37 PM by Sunny Talwar RSS

    Pivot Table error in SubTotals

      Hi,

      I have a problem on the table listed below, because subtotals are corrected but if I check them manually I have some differences on single lines.

      Here's the code:

       

      -((IF(SUM(W_COSTO_VENDUTO_X_SALDI_ITA)>0,((SUM(IF(CONTO_COSTO='0606000002', IMPORTO_CONTO_COSTO))+

      (SUM(IF(CONTO_COSTO='0606000008' , IMPORTO_CONTO_COSTO))+

      (SUM(IF(CONTO_COSTO='0606000011' , IMPORTO_CONTO_COSTO))+

      (SUM(IF(CONTO_COSTO='0606070001' , IMPORTO_CONTO_COSTO))+

      (SUM(IF(CONTO_COSTO='0606070011', IMPORTO_CONTO_COSTO)))))))),'0,00')))

       

      /(SUM(TOTAL(IF(C_NAZIONE_QLIK='I' and  NOT CD_ARTICOLO_STATISTICO LIKE '31*'

      AND NOT CD_ARTICOLO_STATISTICO LIKE '70*'

      AND NOT CD_ARTICOLO_STATISTICO LIKE '.ADD*'

      AND NOT CD_ARTICOLO_STATISTICO LIKE '.SPTR*'

      AND NOT CD_ARTICOLO_STATISTICO LIKE '40*'

      AND C_ARTICOLO <>'L'

      AND C_ARTICOLO<>'.FA'

      AND C_CLASSE_4_ARTICOLO <>'VI'

      , W_FT_Q_BASE))))

       

      *SUM(IF(C_NAZIONE_QLIK='I' and NOT CD_ARTICOLO_STATISTICO LIKE '31*'

      AND NOT CD_ARTICOLO_STATISTICO LIKE '70*'

      AND NOT CD_ARTICOLO_STATISTICO LIKE '.ADD*'

      AND NOT CD_ARTICOLO_STATISTICO LIKE '.SPTR*'

      AND NOT CD_ARTICOLO_STATISTICO LIKE '40*'

      AND C_ARTICOLO <>'L'

      AND C_ARTICOLO<>'.FA'

      AND C_CLASSE_4_ARTICOLO <>'VI'

      , W_FT_Q_BASE))

       

      Anyone has an idea on this problem?

      Thank you for your help.