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

    Sum of a sum



      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