4 Replies Latest reply on Jan 29, 2016 1:09 PM by siplus

    Min ( ) and Sum ( ) across related tables not working

    MFalaschi

      Hi everyone!

       

      I´m trying to perform some calculations across related tables, and i don't know why it's not working...

       

      I have a table called "Sectores de Incendio" and another called "Relevamiento de Materiales"

       

      "Sector de Incendio" fields: (among others) 

                     Nombre Sector

                     Riesgo Sector

                     Carga Fuego A

                     Carga Fuego B

       

      ¨Relevamiento de Materiales¨ fields: (among others)

                     Nombre Sector

                     Riesgo Material

                     Cargas Calorificas A

                     Cargas Calorificas B

       

      they are related by a field called "Nombre Sector"

       

      the field Riesgo Sector is defined as the calculation Min ( Relevamiento Materiales::Riesgo Material )

      Carga Fuego A is defined as the calculation Sum ( Relevamiento Materiales::Cargas Calorificas A )

      Carga Fuego B is defined as the calculation Sum ( Relevamiento Materiales::Cargas Calorificas B )

       

      Neither of does calculation is working and i can´t figure out why!!!

      Picture to further clarify:

       

      Sin título.tiffAny ideas are welcomed!

      Thanks!