'Total' Of Fields-Help

[Solidlite]

Hi,

 

Have a slight problem. I'm trying to get a total of a set of fields .

 

I have in my fields;

 

H3 Incoming'

 

H3 Aqueous

 

H3 Gaseous

 

H3 VLLW

 

H3 Stock

 

All which have different figures in. I made a new field called H3 Total and selected Summary with 'Total of' but It will only let me select on of the above, rather the the group. Is there a way I can total all the above to  a final H3 Total?

 

Thank you very much for your help.

[Wim Decorte]

Sounds like this may be a data architecture issue and that the H3 fields should be a set of related records.  Then you can just sum across the relationship.

 

In your current structure you can create a new field:

 

sum( H3 incoming ; H3 Aqueous ; ...)

[comment]

Your question is not clear. Do you want to get the sum of the 5 values in the same record - or in the entire found set?

 

You didn't provide any details about what this data represents in real life; I suspect it might be better to use a separate table for these quantities - with a field for the type (Incoming/Aqueous/Gaseous/VLLW/Stock) and a field for the quantity.

[Solidlite]

Sounds like this may be a data architecture issue and that the H3 fields should be a set of related records.  Then you can just sum across the relationship.

 

In your current structure you can create a new field:

 

sum( H3 incoming ; H3 Aqueous ; ...)

 

 

Thank you, I used your calculation 

[Solidlite]

Sorry to be a pain but I'm not sure if I am doing this right. Trying to get a monthly sum of all the fields and possibly the yearly sum. Am I allowed to attach the file, if it helps ?

 

Thank you. 

[Solidlite]

My File add.

 

Thank you. 

RP2A.zip