3 Replies Latest reply: Apr 17, 2013 3:23 AM by Óscar Iglesias RSS

    Problem with set analysis in table

      Hello,

      I have a problem with a column in wich I am using set analysis. I attached an example with my problem.

       

      Captura.PNG

       

      I have two tables, "Epigrafes" and "Movimientos". Both are related by the column Cuenta.

       

      What I need is to modify the expression of column "Total" in the table "Resultado" to display the sum of the amounts ("Importes") for column related FilaTotal.

      Example:

       

      Captura.PNG

       

      This is what I need. Rows 3, 4 and 5 have to show the sum of row 5. And 6, 7, 8 and 9 rows the sum of row 9.

       

      I've tried with the expression: =SUM({$<Epigrafe=,Orden={'=FilaTotal'}>}Importes)

      but it doesn't works.

       

      Can you help me?

       

      Best regards,

       

       

      Oscar Iglesias.