0 Replies Latest reply: Jun 19, 2013 4:31 PM by Rodrigo Lauro RSS

    Pivot Grid Partial Total are wrong !!!

    Rodrigo Lauro

      Hi,
      Can someone help me with this?

       

      I have almost the same problem. I have an Expression  that is the multiplication of two parts (Part A * part B).
      When I make the sum of my own for the two parts, and then multiply both TOTALS it is correct. But it is not the correct total for the pivot grid.

       

      This is the Expression

      (Sum(STOCK_AL_CIERRE_AJU)  - Sum(VENTA_AJU) + Sum(CAJAS))     // PART A

           *   

      (sum(NIV)/sum( CAJAS)) // PART B

       

       

      I only use one Dimension, it is YearMonth.