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

    Problem with set analysis in table


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




      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.





      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.