AnsweredAssumed Answered

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

Question asked by MFalaschi on Jan 29, 2016
Latest reply on Jan 29, 2016 by siplus

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!

Outcomes