Jump to content

'Total' Of Fields-Help


This topic is 2810 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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. :)

Link to comment
Share on other sites

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 ; ...)

  • Like 2
Link to comment
Share on other sites

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.

  • Like 1
Link to comment
Share on other sites

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  :)

Link to comment
Share on other sites

This topic is 2810 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.