5 Replies Latest reply: Nov 30, 2011 10:25 AM by Community Administrator RSS

    Sum of a sum

      Hello,

       

      I building a table with P&L values and i want to present the cumulative sum of all the groups except the taxes one in one row of the table.

      I start with this but i get no result.

       

       

      if (PresentatieVolgorde.Group like 'Value before taxes',

                if (PresentatieVolgorde.group = 'taxes',

                        sum(  aggr( Sum ([P&L Detail.Value]),Boeking)))

       

       

       

      Can someone please help me?

       

      Best regards

      Piskitta