Jump to content

Help to calculate Sub Total field of found records


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

Recommended Posts

Hi I am trying to find away to calculate the the total sum held in a field named "sub total" on all FOUND records, can anyone advise please?

eg. record1 shows a sub total of 21000 record4 shows a sub total of 5000 therefore it should show the calculation of 26000 in the target field.

records 2 & 3 are not in the found set and should be ignored.

Thanks in advance for any help offered.

Link to comment
Share on other sites

43 minutes ago, beckham said:

record1 shows a sub total of 21000 record4 shows a sub total of 5000 therefore it should show the calculation of 26000 in the target field.

I am not sure what you man by "sub total" here. In general, you would use a summary field to total the values in a field for all records of the found set.

Link to comment
Share on other sites

This topic is 2291 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.